APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 383: FROM JAI_CMN_INVENTORY_ORGS

379: --added by ssawant
380: CURSOR cur_qty_setup( cp_organization_id NUMBER,cp_location_id NUMBER)
381: IS
382: SELECT quantity_register_update_event
383: FROM JAI_CMN_INVENTORY_ORGS
384: WHERE organization_id = cp_organization_id
385: AND location_id = cp_location_id ;
386:
387:

Line 3116: FROM JAI_CMN_INVENTORY_ORGS

3112: AND inventory_item_id = cp_inventory_item_id;
3113:
3114: CURSOR c_loc_orgn_dtls(cp_organization_id IN NUMBER) IS
3115: SELECT decode( manufacturing, 'Y', 'M', decode(trading, 'Y', 'T', 'X')) organization_type, excise_in_rg23d
3116: FROM JAI_CMN_INVENTORY_ORGS
3117: WHERE organization_id = cp_organization_id
3118: AND location_id = 0;
3119:
3120: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS

Line 4473: FROM JAI_CMN_INVENTORY_ORGS

4469:
4470: CURSOR c_organization_info(cp_organization_id number) IS
4471: SELECT nvl(trading, 'N') trading, nvl(manufacturing, 'N') manufacturing
4472: , nvl(excise_in_rg23d, 'N') excise_in_rg23d -- Vijay Shankar for Bug#4171469
4473: FROM JAI_CMN_INVENTORY_ORGS
4474: WHERE organization_id = cp_organization_id
4475: AND rownum = 1;
4476:
4477: lb_process_iso_transaction BOOLEAN; --File.Sql.35 Cbabu := true;