DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on MTL_SYSTEM_ITEMS

Line 969: MTL_SYSTEM_ITEMS_KFV MSI,

965: EXISTS (
966: SELECT
967: 'X'
968: FROM
969: MTL_SYSTEM_ITEMS_KFV MSI,
970: FINANCIALS_SYSTEM_PARAMS_ALL FSP
971: WHERE
972: NVL(FSP.ORG_ID, -9999) = NVL(sel_org_id,-9999) AND
973: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND

Line 4432: MTL_SYSTEM_ITEMS MSI,

4428: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
4429: SELECTED_ITEM_ID IS NOT NULL AND
4430: NOT EXISTS (SELECT 'X'
4431: FROM
4432: MTL_SYSTEM_ITEMS MSI,
4433: FINANCIALS_SYSTEM_PARAMS_ALL FSP
4434: WHERE
4435: MSI.INVENTORY_ITEM_ID = SELECTED_ITEM_ID AND
4436: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND

Line 4478: MTL_SYSTEM_ITEMS MSI,

4474: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
4475: SELECTED_ITEM_ID IS NOT NULL AND
4476: NOT EXISTS (SELECT 'X'
4477: FROM
4478: MTL_SYSTEM_ITEMS MSI,
4479: FINANCIALS_SYSTEM_PARAMS_ALL FSP
4480: WHERE
4481: MSI.INVENTORY_ITEM_ID = SELECTED_ITEM_ID AND
4482: MSI.PURCHASING_ENABLED_FLAG = 'Y' AND

Line 4538: MTL_SYSTEM_ITEMS MSI,

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

Line 4658: MTL_SYSTEM_ITEMS_KFV MSI,

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
4662: FSP.ORG_ID = SELECTED_ORG_ID AND