DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1551: MTL_SYSTEM_ITEMS_KFV MSI,

1547: EXISTS (
1548: SELECT
1549: 'X'
1550: FROM
1551: MTL_SYSTEM_ITEMS_KFV MSI,
1552: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1553: WHERE
1554: NVL(FSP.ORG_ID, -9999) = NVL(sel_org_id,-9999) AND
1555: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND

Line 1739: MTL_SYSTEM_ITEMS_KFV MSI,

1735: EXISTS (
1736: SELECT
1737: 'X'
1738: FROM
1739: MTL_SYSTEM_ITEMS_KFV MSI,
1740: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1741: WHERE
1742: NVL(FSP.ORG_ID, -9999) = NVL(sel_org_id,-9999) AND
1743: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND

Line 5508: MTL_SYSTEM_ITEMS_KFV MSI,

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