DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 5386: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

5382: SELECTED_ITEM_ID IS NOT NULL AND
5383: SELECTED_ITEM_REVISION IS NOT NULL AND
5384: SELECTED_SHIP_TO_ORG_ID NOT IN
5385: (SELECT OOD.ORGANIZATION_ID
5386: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
5387: MTL_SYSTEM_ITEMS MSI,
5388: MTL_ITEM_REVISIONS MIR,
5389: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
5390: PO_LINE_TYPES_B PLTB

Line 5507: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

5503: SELECTED_ITEM_ID IS NOT NULL AND
5504: SELECTED_ITEM_REVISION IS NULL AND
5505: SELECTED_SHIP_TO_ORG_ID NOT IN
5506: (SELECT OOD.ORGANIZATION_ID
5507: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
5508: MTL_SYSTEM_ITEMS_KFV MSI,
5509: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
5510: PO_LINE_TYPES_B PLTB
5511: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND

Line 5558: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

5554: SELECTED_SHIP_TO_ORG_ID IS NOT NULL AND
5555: SELECTED_ITEM_ID IS NULL AND
5556: SELECTED_SHIP_TO_ORG_ID NOT IN
5557: (SELECT OOD.ORGANIZATION_ID
5558: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
5559: FINANCIALS_SYSTEM_PARAMS_ALL FSP
5560: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
5561: FSP.ORG_ID = SELECTED_ORG_ID AND
5562: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) )