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.DPP_UTILITY_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 622: financials_system_params_all fspa,

618: msi.concatenated_segments,
619: msi.description,
620: occ.external_code
621: FROM mtl_system_items_kfv msi,
622: financials_system_params_all fspa,
623: ozf_supp_code_conversions_all occ
624: WHERE occ.internal_code = to_char(msi.inventory_item_id)
625: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
626: AND occ.supp_trade_profile_id = p_supp_trade_profile_id

Line 648: financials_system_params_all fspa

644: msi.concatenated_segments,
645: msi.description,
646: null external_code
647: FROM mtl_system_items_kfv msi,
648: financials_system_params_all fspa
649: WHERE msi.purchasing_item_flag = 'Y'
650: AND msi.shippable_item_flag = 'Y'
651: AND msi.enabled_flag = 'Y'
652: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned

Line 678: financials_system_params_all fspa

674: msi.concatenated_segments,
675: msi.description,
676: NULL external_code
677: FROM mtl_system_items_kfv msi,
678: financials_system_params_all fspa
679: WHERE msi.organization_id = fspa.inventory_organization_id
680: AND msi.purchasing_item_flag = 'Y'
681: AND msi.shippable_item_flag = 'Y'
682: AND msi.enabled_flag = 'Y'

Line 830: financials_system_params_all fspa,

826: msi.description
827: FROM
828: mtl_system_items_kfv msi,
829: mtl_parameters mp,
830: financials_system_params_all fspa,
831: oe_order_lines_all oola,
832: dpp_transaction_lines_all dtla
833: WHERE
834: dtla.transaction_header_id = TO_NUMBER(p_search_text1) and

Line 922: financials_system_params_all fspa,

918: msi.description
919: FROM
920: mtl_system_items_kfv msi,
921: mtl_parameters mp,
922: financials_system_params_all fspa,
923: dpp_transaction_lines_all dtla
924: WHERE
925: dtla.transaction_header_id = TO_NUMBER(p_search_text1) AND
926: p_search_criteria1 = 'TRANSACTION_HEADER_ID' AND

Line 1958: financials_system_params_all fspa

1954: SELECT
1955: msi.LIST_PRICE_PER_UNIT list_price
1956: FROM
1957: mtl_system_items msi,
1958: financials_system_params_all fspa
1959: WHERE
1960: msi.organization_id = fspa.inventory_organization_id and
1961: fspa.org_id = p_organization_id and
1962: msi.inventory_item_id = p_inventory_item_id;

Line 2370: financials_system_params_all fspa

2366: IS
2367: SELECT concatenated_segments,
2368: description
2369: FROM mtl_system_items_kfv msi,
2370: financials_system_params_all fspa
2371: WHERE fspa.org_id = p_org_id and
2372: fspa.inventory_organization_id = msi.organization_id and
2373: msi.inventory_item_id = p_inventory_item_id;
2374: