eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1552: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
1556: MSI.INVENTORY_ITEM_ID = sel_item_id AND

Line 1740: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
1744: MSI.INVENTORY_ITEM_ID = sel_item_id AND

Line 5200: FINANCIALS_SYSTEM_PARAMS_ALL FSP

5196: SELECTED_ITEM_ID IS NOT NULL AND
5197: NOT EXISTS (SELECT 'X'
5198: FROM MTL_ITEM_CATEGORIES MIC,
5199: MTL_DEFAULT_SETS_VIEW MDSV,
5200: FINANCIALS_SYSTEM_PARAMS_ALL FSP
5201: WHERE MIC.INVENTORY_ITEM_ID = SELECTED_ITEM_ID
5202: AND MIC.ORGANIZATION_ID =
5203: FSP.INVENTORY_ORGANIZATION_ID
5204: AND NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999)

Line 5279: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
5283: NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999) AND

Line 5325: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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
5329: MSI.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID AND

Line 5389: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

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
5393: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND

Line 5509: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

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
5513: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND

Line 5559: FINANCIALS_SYSTEM_PARAMS_ALL FSP

5555: SELECTED_ITEM_ID IS NULL AND
5556: SELECTED_SHIP_TO_ORG_ID NOT IN
5557: (SELECT OOD.ORGANIZATION_ID
5558: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
5559: FINANCIALS_SYSTEM_PARAMS_ALL FSP
5560: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
5561: FSP.ORG_ID = SELECTED_ORG_ID AND
5562: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) )
5563: )