APPS.JAI_PO_OSP_PKG dependencies on JAI_INV_ITM_SETUPS

Line 200: FROM JAI_INV_ITM_SETUPS

196: AND nvl(cancel_flag,'N') = 'N' ;/*5699863 - csahoo */
197:
198: CURSOR c_Excise_Flag(cp_org_id NUMBER, cp_item_id NUMBER) IS
199: SELECT excise_flag, item_tariff
200: FROM JAI_INV_ITM_SETUPS
201: WHERE inventory_item_id = cp_item_id
202: AND organization_id = cp_org_id;
203:
204: --******************FETCHING FORM ID FROM SEQUENCE************

Line 363: lv_Excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;

359: ln_po_qty number;
360: lv_source_code varchar2(1) ;
361: ln_item_unit_price number;
362: lv_osp_po varchar2(1);
363: lv_Excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
364: lv_tariff_code JAI_INV_ITM_SETUPS.item_tariff%type;
365: rec_po_line_cur c_po_line_cur%rowtype;
366: ln_location_id number;
367: ln_routing_seq_id number;

Line 364: lv_tariff_code JAI_INV_ITM_SETUPS.item_tariff%type;

360: lv_source_code varchar2(1) ;
361: ln_item_unit_price number;
362: lv_osp_po varchar2(1);
363: lv_Excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
364: lv_tariff_code JAI_INV_ITM_SETUPS.item_tariff%type;
365: rec_po_line_cur c_po_line_cur%rowtype;
366: ln_location_id number;
367: ln_routing_seq_id number;
368: ln_routing_ctr number;

Line 883: FROM JAI_INV_ITM_SETUPS

879: WHERE shipment_line_id = r_base_trx.shipment_line_id;
880:
881: CURSOR c_Excise_Flag (v_item_id NUMBER) IS
882: SELECT excise_flag, item_tariff
883: FROM JAI_INV_ITM_SETUPS
884: WHERE inventory_item_id = v_item_id
885: AND organization_id = r_base_trx.organization_id;
886:
887: CURSOR c_po_line_info IS