APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 479: from JAI_CMN_INVENTORY_ORGS

475: where customer_trx_id = pr_new.customer_trx_id;
476:
477: cursor c_default_location(CP_ORGANIZATION_ID number) is
478: select DEFAULT_LOCATION_BILL_ONLY
479: from JAI_CMN_INVENTORY_ORGS
480: where organization_id = cp_organization_id
481: and location_id = 0;
482:
483: cursor c_oe_system_params is

Line 3199: FROM JAI_CMN_INVENTORY_ORGS

3195: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
3196:
3197: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
3198: SELECT pref_rg23a, pref_rg23c, pref_pla
3199: FROM JAI_CMN_INVENTORY_ORGS
3200: WHERE organization_id = p_organization_id
3201: AND location_id = p_location_id ;
3202:
3203: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS

Line 3211: FROM JAI_CMN_INVENTORY_ORGS

3207: AND location_id = p_location_id ;
3208:
3209: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
3210: SELECT ssi_unit_flag
3211: FROM JAI_CMN_INVENTORY_ORGS
3212: WHERE organization_id = p_organization_id AND
3213: location_id = p_location_id;
3214:
3215: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS

Line 3245: FROM JAI_CMN_INVENTORY_ORGS A

3241: AND register_code = p_register_code ;
3242:
3243: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
3244: SELECT A.Organization_Id, A.Location_Id
3245: FROM JAI_CMN_INVENTORY_ORGS A
3246: WHERE A.Ec_Code IN (SELECT B.Ec_Code
3247: FROM JAI_CMN_INVENTORY_ORGS B
3248: WHERE B.Organization_Id = p_organization_id
3249: AND B.Location_Id = p_location_id);

Line 3247: FROM JAI_CMN_INVENTORY_ORGS B

3243: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
3244: SELECT A.Organization_Id, A.Location_Id
3245: FROM JAI_CMN_INVENTORY_ORGS A
3246: WHERE A.Ec_Code IN (SELECT B.Ec_Code
3247: FROM JAI_CMN_INVENTORY_ORGS B
3248: WHERE B.Organization_Id = p_organization_id
3249: AND B.Location_Id = p_location_id);
3250:
3251: CURSOR site_cur IS

Line 5066: from JAI_CMN_INVENTORY_ORGS

5062: where customer_trx_id = pr_new.customer_trx_id;
5063:
5064: cursor c_default_location(CP_ORGANIZATION_ID number) is
5065: select DEFAULT_LOCATION_BILL_ONLY
5066: from JAI_CMN_INVENTORY_ORGS
5067: where organization_id = cp_organization_id
5068: and location_id = 0;
5069:
5070: cursor c_oe_system_params is