APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1158: FROM JAI_CMN_INVENTORY_ORGS

1154: --2001/04/20 Anuradha Parthasarathy
1155:
1156: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1157: SELECT pref_rg23a, pref_rg23c, pref_pla
1158: FROM JAI_CMN_INVENTORY_ORGS
1159: WHERE organization_id = p_organization_id
1160: AND location_id = p_location_id ;
1161:
1162: v_pref_rg23a NUMBER;

Line 1187: FROM JAI_CMN_INVENTORY_ORGS

1183: AND location_id = p_location_id ;
1184:
1185: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1186: SELECT ssi_unit_flag
1187: FROM JAI_CMN_INVENTORY_ORGS
1188: WHERE organization_id = p_organization_id AND
1189: location_id = p_location_id;
1190:
1191: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS

Line 1237: FROM JAI_CMN_INVENTORY_ORGS A

1233: v_exc_invoice_no VARCHAR2(200);
1234: v_reg_code VARCHAR2(30);
1235: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1236: SELECT A.Organization_Id, A.Location_Id
1237: FROM JAI_CMN_INVENTORY_ORGS A
1238: WHERE A.Ec_Code IN (SELECT B.Ec_Code
1239: FROM JAI_CMN_INVENTORY_ORGS B
1240: WHERE B.Organization_Id = p_organization_id
1241: AND B.Location_Id = p_location_id);

Line 1239: FROM JAI_CMN_INVENTORY_ORGS B

1235: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1236: SELECT A.Organization_Id, A.Location_Id
1237: FROM JAI_CMN_INVENTORY_ORGS A
1238: WHERE A.Ec_Code IN (SELECT B.Ec_Code
1239: FROM JAI_CMN_INVENTORY_ORGS B
1240: WHERE B.Organization_Id = p_organization_id
1241: AND B.Location_Id = p_location_id);
1242:
1243: v_source_name VARCHAR2(100); --File.Sql.35 Cbabu := 'Receivables India';

Line 1829: from JAI_CMN_INVENTORY_ORGS

1825: where customer_trx_id = pr_new.customer_trx_id;
1826:
1827: cursor c_default_location(CP_ORGANIZATION_ID number) is
1828: select DEFAULT_LOCATION_BILL_ONLY
1829: from JAI_CMN_INVENTORY_ORGS
1830: where organization_id = cp_organization_id
1831: and location_id = 0;
1832:
1833: cursor c_oe_system_params is