APPS.JAI_RCV_RND_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 178: FROM JAI_CMN_INVENTORY_ORGS

174: AND fin_active_flag = 'Y';
175:
176: CURSOR c_rg_rounding_account(p_organization_id IN NUMBER) IS
177: SELECT rg_rounding_account_id
178: FROM JAI_CMN_INVENTORY_ORGS
179: WHERE organization_id = p_organization_id
180: AND ( location_id IS NULL OR location_id = 0);
181:
182: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS

Line 184: FROM JAI_CMN_INVENTORY_ORGS

180: AND ( location_id IS NULL OR location_id = 0);
181:
182: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
183: SELECT modvat_rm_account_id, modvat_cg_account_id
184: FROM JAI_CMN_INVENTORY_ORGS
185: WHERE organization_id = p_organization_id
186: AND location_id = p_location_id;
187:
188: ln_receive_qty NUMBER;

Line 2047: FROM JAI_CMN_INVENTORY_ORGS

2043: AND fin_active_flag = 'Y';
2044:
2045: CURSOR c_rg_rounding_account(p_organization_id IN NUMBER) IS
2046: SELECT rg_rounding_account_id
2047: FROM JAI_CMN_INVENTORY_ORGS
2048: WHERE organization_id = p_organization_id
2049: AND ( location_id IS NULL OR location_id = 0);
2050:
2051: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS

Line 2053: FROM JAI_CMN_INVENTORY_ORGS

2049: AND ( location_id IS NULL OR location_id = 0);
2050:
2051: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
2052: SELECT modvat_rm_account_id, modvat_cg_account_id, modvat_pla_account_id
2053: FROM JAI_CMN_INVENTORY_ORGS
2054: WHERE organization_id = p_organization_id
2055: AND location_id = p_location_id;
2056:
2057: ln_receive_qty NUMBER;