APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1229: FROM JAI_CMN_INVENTORY_ORGS

1225: --2001/04/20 Anuradha Parthasarathy
1226:
1227: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1228: SELECT pref_rg23a, pref_rg23c, pref_pla
1229: FROM JAI_CMN_INVENTORY_ORGS
1230: WHERE organization_id = p_organization_id
1231: AND location_id = p_location_id ;
1232:
1233: v_pref_rg23a NUMBER;

Line 1258: FROM JAI_CMN_INVENTORY_ORGS

1254: AND location_id = p_location_id ;
1255:
1256: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1257: SELECT ssi_unit_flag
1258: FROM JAI_CMN_INVENTORY_ORGS
1259: WHERE organization_id = p_organization_id AND
1260: location_id = p_location_id;
1261:
1262: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS

Line 1308: FROM JAI_CMN_INVENTORY_ORGS A

1304: v_exc_invoice_no VARCHAR2(200);
1305: v_reg_code VARCHAR2(30);
1306: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1307: SELECT A.Organization_Id, A.Location_Id
1308: FROM JAI_CMN_INVENTORY_ORGS A
1309: WHERE A.Ec_Code IN (SELECT B.Ec_Code
1310: FROM JAI_CMN_INVENTORY_ORGS B
1311: WHERE B.Organization_Id = p_organization_id
1312: AND B.Location_Id = p_location_id);

Line 1310: FROM JAI_CMN_INVENTORY_ORGS B

1306: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
1307: SELECT A.Organization_Id, A.Location_Id
1308: FROM JAI_CMN_INVENTORY_ORGS A
1309: WHERE A.Ec_Code IN (SELECT B.Ec_Code
1310: FROM JAI_CMN_INVENTORY_ORGS B
1311: WHERE B.Organization_Id = p_organization_id
1312: AND B.Location_Id = p_location_id);
1313:
1314: v_source_name VARCHAR2(100); --File.Sql.35 Cbabu := 'Receivables India';

Line 2039: from JAI_CMN_INVENTORY_ORGS

2035: where customer_trx_id = pr_new.customer_trx_id;
2036:
2037: cursor c_default_location(CP_ORGANIZATION_ID number) is
2038: select DEFAULT_LOCATION_BILL_ONLY
2039: from JAI_CMN_INVENTORY_ORGS
2040: where organization_id = cp_organization_id
2041: and location_id = 0;
2042:
2043: cursor c_oe_system_params is

Line 4771: from JAI_CMN_INVENTORY_ORGS

4767: where customer_trx_id = pr_new.customer_trx_id;
4768:
4769: cursor c_default_location(CP_ORGANIZATION_ID number) is
4770: select DEFAULT_LOCATION_BILL_ONLY
4771: from JAI_CMN_INVENTORY_ORGS
4772: where organization_id = cp_organization_id
4773: and location_id = 0;
4774:
4775: cursor c_oe_system_params is

Line 6027: JAI_CMN_INVENTORY_ORGS jcio

6023:
6024: CURSOR get_loc_cur IS
6025: SELECT hl.location_id
6026: FROM hr_locations hl,
6027: JAI_CMN_INVENTORY_ORGS jcio
6028: WHERE hl.location_id = jcio.location_id
6029: AND jcio.organization_id = pr_new.warehouse_id;
6030:
6031: BEGIN