APPS.JAI_PO_OSP_PKG dependencies on JAI_INV_ITM_SETUPS

Line 142: FROM JAI_INV_ITM_SETUPS

138: AND nvl(cancel_flag,'N') = 'N' ;/*5699863 - csahoo */
139:
140: CURSOR c_Excise_Flag(cp_org_id NUMBER, cp_item_id NUMBER) IS
141: SELECT excise_flag, item_tariff
142: FROM JAI_INV_ITM_SETUPS
143: WHERE inventory_item_id = cp_item_id
144: AND organization_id = cp_org_id;
145:
146: --******************FETCHING FORM ID FROM SEQUENCE************

Line 303: lv_Excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;

299: ln_po_qty number;
300: lv_source_code varchar2(1) ;
301: ln_item_unit_price number;
302: lv_osp_po varchar2(1);
303: lv_Excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
304: lv_tariff_code JAI_INV_ITM_SETUPS.item_tariff%type;
305: rec_po_line_cur c_po_line_cur%rowtype;
306: ln_location_id number;
307: ln_routing_seq_id number;

Line 304: lv_tariff_code JAI_INV_ITM_SETUPS.item_tariff%type;

300: lv_source_code varchar2(1) ;
301: ln_item_unit_price number;
302: lv_osp_po varchar2(1);
303: lv_Excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
304: lv_tariff_code JAI_INV_ITM_SETUPS.item_tariff%type;
305: rec_po_line_cur c_po_line_cur%rowtype;
306: ln_location_id number;
307: ln_routing_seq_id number;
308: ln_routing_ctr number;

Line 762: FROM JAI_INV_ITM_SETUPS

758: WHERE shipment_line_id = r_base_trx.shipment_line_id;
759:
760: CURSOR c_Excise_Flag (v_item_id NUMBER) IS
761: SELECT excise_flag, item_tariff
762: FROM JAI_INV_ITM_SETUPS
763: WHERE inventory_item_id = v_item_id
764: AND organization_id = r_base_trx.organization_id;
765:
766: CURSOR c_po_line_info IS