DBA Data[Home] [Help]

APPS.ITG_X_UTILS dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 81: ** given the org_id using the financials_system_params_all table

77: end getFlexQualifierSegment;
78:
79: /*
80: ** get_inventory_org_id is used to get the inventory_organization_id
81: ** given the org_id using the financials_system_params_all table
82: */
83: FUNCTION get_inventory_org_id (p_org_id NUMBER)
84: RETURN NUMBER AS
85: CURSOR cur_fin_system_params IS

Line 87: FROM financials_system_params_all

83: FUNCTION get_inventory_org_id (p_org_id NUMBER)
84: RETURN NUMBER AS
85: CURSOR cur_fin_system_params IS
86: SELECT inventory_organization_id
87: FROM financials_system_params_all
88: WHERE org_id=p_org_id;
89: v_inv_org financials_system_params_all.inventory_organization_id%TYPE;
90: BEGIN
91: OPEN cur_fin_system_params;

Line 89: v_inv_org financials_system_params_all.inventory_organization_id%TYPE;

85: CURSOR cur_fin_system_params IS
86: SELECT inventory_organization_id
87: FROM financials_system_params_all
88: WHERE org_id=p_org_id;
89: v_inv_org financials_system_params_all.inventory_organization_id%TYPE;
90: BEGIN
91: OPEN cur_fin_system_params;
92: FETCH cur_fin_system_params INTO v_inv_org;
93: CLOSE cur_fin_system_params;

Line 198: FROM financials_system_params_all fsp,

194: AND ap.org_id = orgId
195: AND unit.organization_id = orgUnit;
196: CURSOR getVRN IS
197: SELECT fsp.vat_registration_num
198: FROM financials_system_params_all fsp,
199: inv_organization_info_v org -- Modified for performance bug#4941286
200: WHERE fsp.set_of_books_id = org.set_of_books_id
201: AND org.organization_id = invOrg;
202: taxId varchar2(100);