Monday, 2 September 2013

Receipt Number for particular Organization

Firstly This View Create :

CREATE OR REPLACE FORCE VIEW APPS.Demo_RECEIPT_NUMBER_V
(
   RECEIPT_NUM,
   SHIPMENT_HEADER_ID,
   ORG_ID
)
AS
     SELECT rsh.RECEIPT_NUM, RSH.SHIPMENT_HEADER_ID, ph.ORG_ID
       FROM RCV_SHIPMENT_HEADERS rsh, RCV_SHIPMENT_LINES rsl, PO_HEADERS_ALL PH
      WHERE     RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
            AND PH.PO_HEADER_ID = RSL.PO_HEADER_ID
            AND ph.ORG_ID = fnd_profile.VALUE ('ORG_ID')
   ORDER BY rsh.RECEIPT_NUM

===============================
And After That This View Use In Value Set
and this code write in where clause
ORG_ID= fnd_profile.value('ORG_ID')

No comments:

Post a Comment