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 970: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 4354: FINANCIALS_SYSTEM_PARAMS_ALL FSP

4350: SELECTED_ITEM_ID IS NOT NULL AND
4351: NOT EXISTS (SELECT 'X'
4352: FROM MTL_ITEM_CATEGORIES MIC,
4353: MTL_DEFAULT_SETS_VIEW MDSV,
4354: FINANCIALS_SYSTEM_PARAMS_ALL FSP
4355: WHERE MIC.INVENTORY_ITEM_ID = SELECTED_ITEM_ID
4356: AND MIC.ORGANIZATION_ID =
4357: FSP.INVENTORY_ORGANIZATION_ID
4358: AND NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999)

Line 4433: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 4479: FINANCIALS_SYSTEM_PARAMS_ALL FSP

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

Line 4540: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

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

Line 4659: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

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

Line 4709: FINANCIALS_SYSTEM_PARAMS_ALL FSP

4705: SELECTED_ITEM_ID IS NULL AND
4706: SELECTED_SHIP_TO_ORG_ID NOT IN
4707: (SELECT OOD.ORGANIZATION_ID
4708: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4709: FINANCIALS_SYSTEM_PARAMS_ALL FSP
4710: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4711: FSP.ORG_ID = SELECTED_ORG_ID AND
4712: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) )
4713: )