DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 4537: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

4533: SELECTED_ITEM_ID IS NOT NULL AND
4534: SELECTED_ITEM_REVISION IS NOT NULL AND
4535: SELECTED_SHIP_TO_ORG_ID NOT IN
4536: (SELECT OOD.ORGANIZATION_ID
4537: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4538: MTL_SYSTEM_ITEMS MSI,
4539: MTL_ITEM_REVISIONS MIR,
4540: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
4541: PO_LINE_TYPES_B PLTB

Line 4657: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

4653: SELECTED_ITEM_ID IS NOT NULL AND
4654: SELECTED_ITEM_REVISION IS NULL AND
4655: SELECTED_SHIP_TO_ORG_ID NOT IN
4656: (SELECT OOD.ORGANIZATION_ID
4657: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4658: MTL_SYSTEM_ITEMS_KFV MSI,
4659: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
4660: PO_LINE_TYPES_B PLTB
4661: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND

Line 4708: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

4704: SELECTED_SHIP_TO_ORG_ID IS NOT NULL AND
4705: SELECTED_ITEM_ID IS NULL AND
4706: SELECTED_SHIP_TO_ORG_ID NOT IN
4707: (SELECT OOD.ORGANIZATION_ID
4708: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4709: FINANCIALS_SYSTEM_PARAMS_ALL FSP
4710: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4711: FSP.ORG_ID = SELECTED_ORG_ID AND
4712: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) )