[Home] [Help]
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
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
5274: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
5275: SELECTED_ITEM_ID IS NOT NULL AND
5276: NOT EXISTS (SELECT 'X'
5277: FROM
5278: MTL_SYSTEM_ITEMS MSI,
5279: FINANCIALS_SYSTEM_PARAMS_ALL FSP
5280: WHERE
5281: MSI.INVENTORY_ITEM_ID = SELECTED_ITEM_ID AND
5282: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND
5320: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
5321: SELECTED_ITEM_ID IS NOT NULL AND
5322: NOT EXISTS (SELECT 'X'
5323: FROM
5324: MTL_SYSTEM_ITEMS MSI,
5325: FINANCIALS_SYSTEM_PARAMS_ALL FSP
5326: WHERE
5327: MSI.INVENTORY_ITEM_ID = SELECTED_ITEM_ID AND
5328: MSI.PURCHASING_ENABLED_FLAG = 'Y' AND
5383: SELECTED_ITEM_REVISION IS NOT NULL AND
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
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