APPS.PO_SHARED_PROC_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 696: FROM po_requisition_lines_all prl, financials_system_params_all fsp

692: SELECT prl.category_id,
693: nvl(prl.destination_organization_id, fsp.inventory_organization_id),
694: prl.deliver_to_location_id
695: INTO l_category_id, l_dest_inv_org_id, l_deliver_to_location_id
696: FROM po_requisition_lines_all prl, financials_system_params_all fsp
697: WHERE prl.requisition_line_id = p_requisition_line_id
698: AND prl.org_id = fsp.org_id; -- Bug 3379488: Use base table for joins
699:
700: -- MC INVCONV START

Line 904: FROM po_requisition_lines_all prl, financials_system_params_all fsp

900: nvl(prl.destination_organization_id,
901: fsp.inventory_organization_id),
902: prl.deliver_to_location_id
903: INTO l_category_id, l_dest_inv_org_id, l_deliver_to_location_id
904: FROM po_requisition_lines_all prl, financials_system_params_all fsp
905: WHERE prl.requisition_line_id = p_requisition_line_id
906: AND prl.org_id = fsp.org_id;
907:
908: l_progress := '018';

Line 1282: l_current_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE;

1278: x_transaction_flow_header_id OUT NOCOPY NUMBER
1279: )
1280: IS
1281:
1282: l_current_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE;
1283: l_current_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
1284: l_current_p_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1285: l_current_r_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
1286:

Line 1283: l_current_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

1279: )
1280: IS
1281:
1282: l_current_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE;
1283: l_current_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
1284: l_current_p_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1285: l_current_r_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
1286:
1287: l_end_ou_id NUMBER; -- query converts to number

Line 1284: l_current_p_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

1280: IS
1281:
1282: l_current_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE;
1283: l_current_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
1284: l_current_p_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1285: l_current_r_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
1286:
1287: l_end_ou_id NUMBER; -- query converts to number
1288: l_ship_to_org_sob_id NUMBER; -- query converts to number

Line 1285: l_current_r_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;

1281:
1282: l_current_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE;
1283: l_current_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;
1284: l_current_p_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
1285: l_current_r_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
1286:
1287: l_end_ou_id NUMBER; -- query converts to number
1288: l_ship_to_org_sob_id NUMBER; -- query converts to number
1289: l_ship_to_org_opm_flag MTL_PARAMETERS.process_enabled_flag%TYPE;