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

Line 114: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;

110: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Local_ASL';
111: l_api_version CONSTANT NUMBER := 1.0;
112: l_inv_app_id CONSTANT NUMBER := 401;
113:
114: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;

Line 115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;

111: l_api_version CONSTANT NUMBER := 1.0;
112: l_inv_app_id CONSTANT NUMBER := 401;
113:
114: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;

Line 116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;

112: l_inv_app_id CONSTANT NUMBER := 401;
113:
114: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;

Line 170: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,

166: fspa.set_of_books_id
167: INTO l_purch_flag ,
168: l_req_flag ,
169: l_sob_id
170: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,
171: po_vendor_sites_all pvs
172: WHERE pvs.vendor_site_id = p_supplier_site_id
173: AND NVL(fspa.org_id,-99) = NVL(pvs.org_id,-99) ;
174:

Line 431: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;

427: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Global_ASL';
428: l_api_version CONSTANT NUMBER := 1.0;
429: l_inv_app_id CONSTANT NUMBER := 401;
430:
431: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
432: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
433: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
434: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;
435: l_req_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_REQ_NUM_CODE%TYPE;

Line 432: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;

428: l_api_version CONSTANT NUMBER := 1.0;
429: l_inv_app_id CONSTANT NUMBER := 401;
430:
431: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
432: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
433: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
434: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;
435: l_req_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_REQ_NUM_CODE%TYPE;
436:

Line 433: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;

429: l_inv_app_id CONSTANT NUMBER := 401;
430:
431: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
432: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
433: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
434: l_po_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_PO_NUM_CODE%TYPE;
435: l_req_num_code PO_SYSTEM_PARAMETERS.USER_DEFINED_REQ_NUM_CODE%TYPE;
436:
437: e_fail_validation EXCEPTION;

Line 480: financials_system_params_all fspa

476: -- INVCONV and hoi.organization_id = imst.mtl_organization_id (+)
477: and GSOB.SET_OF_BOOKS_ID = (
478: select set_of_books_id
479: from po_vendor_sites_all pvsa ,
480: financials_system_params_all fspa
481: where pvsa.vendor_site_id = p_supplier_site_id
482: and NVL(fspa.org_id,-99)= NVL(pvsa.org_id,-99)
483: ) ;
484:

Line 521: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,

517: fspa.set_of_books_id
518: INTO l_purch_flag ,
519: l_req_flag ,
520: l_sob_id
521: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,
522: po_vendor_sites_all pvs
523: WHERE pvs.vendor_site_id = p_supplier_site_id
524: AND NVL(fspa.org_id,-99) = NVL(pvs.org_id,-99) ;
525:

Line 1621: FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%TYPE;

1617: l_last_billing_date PO_ASL_ATTRIBUTES.last_billing_date%TYPE;
1618: l_cons_billing_cycle PO_ASL_ATTRIBUTES.consigned_billing_cycle%TYPE;
1619: --
1620: l_inventory_org_id
1621: FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%TYPE;
1622:
1623: e_invalid_asset_flag EXCEPTION;
1624: e_invalid_consigned_flag EXCEPTION;
1625: BEGIN

Line 1661: FROM financials_system_params_all

1657: --
1658: -- Get the inventory org ID corresponding to the purchasing org ID.
1659: SELECT inventory_organization_id
1660: INTO l_inventory_org_id
1661: FROM financials_system_params_all
1662: WHERE org_id = p_org_id;
1663: --
1664:
1665: ELSE