APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 581: FROM JAI_CMN_INVENTORY_ORGS

577: --added by ssawant
578: CURSOR cur_qty_setup( cp_organization_id NUMBER,cp_location_id NUMBER)
579: IS
580: SELECT quantity_register_update_event
581: FROM JAI_CMN_INVENTORY_ORGS
582: WHERE organization_id = cp_organization_id
583: AND location_id = cp_location_id ;
584:
585:

Line 3583: FROM JAI_CMN_INVENTORY_ORGS

3579: AND inventory_item_id = cp_inventory_item_id;
3580:
3581: CURSOR c_loc_orgn_dtls(cp_organization_id IN NUMBER) IS
3582: SELECT decode( manufacturing, 'Y', 'M', decode(trading, 'Y', 'T', 'X')) organization_type, excise_in_rg23d
3583: FROM JAI_CMN_INVENTORY_ORGS
3584: WHERE organization_id = cp_organization_id
3585: AND location_id = 0;
3586:
3587: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS

Line 5154: FROM JAI_CMN_INVENTORY_ORGS

5150:
5151: CURSOR c_organization_info(cp_organization_id number) IS
5152: SELECT nvl(trading, 'N') trading, nvl(manufacturing, 'N') manufacturing
5153: , nvl(excise_in_rg23d, 'N') excise_in_rg23d -- Vijay Shankar for Bug#4171469
5154: FROM JAI_CMN_INVENTORY_ORGS
5155: WHERE organization_id = cp_organization_id
5156: AND rownum = 1;
5157:
5158: lb_process_iso_transaction BOOLEAN; --File.Sql.35 Cbabu := true;