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')
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