DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on MTL_ITEM_REVISIONS

Line 5241: FROM MTL_ITEM_REVISIONS

5237: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
5238: SELECTED_ITEM_ID IS NOT NULL AND
5239: SELECTED_ITEM_REVISION IS NOT NULL AND
5240: NOT EXISTS (SELECT 'X'
5241: FROM MTL_ITEM_REVISIONS
5242: WHERE REVISION = SELECTED_ITEM_REVISION AND
5243: INVENTORY_ITEM_ID = SELECTED_ITEM_ID)
5244: )
5245: THEN INTO PON_INTERFACE_ERRORS

Line 5388: MTL_ITEM_REVISIONS MIR,

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
5391: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
5392: FSP.ORG_ID = SELECTED_ORG_ID AND