DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on MTL_ITEM_REVISIONS

Line 4395: FROM MTL_ITEM_REVISIONS

4391: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
4392: SELECTED_ITEM_ID IS NOT NULL AND
4393: SELECTED_ITEM_REVISION IS NOT NULL AND
4394: NOT EXISTS (SELECT 'X'
4395: FROM MTL_ITEM_REVISIONS
4396: WHERE REVISION = SELECTED_ITEM_REVISION AND
4397: INVENTORY_ITEM_ID = SELECTED_ITEM_ID)
4398: )
4399: THEN INTO PON_INTERFACE_ERRORS

Line 4539: MTL_ITEM_REVISIONS MIR,

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