APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 190: v_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE;

186: v_shipped_quantity NUMBER ; --File.Sql.35 Cbabu := nvl(pr_new.shipped_quantity,0) ;
187: v_matched_qty NUMBER ; --File.Sql.35 Cbabu := 0 ;
188: v_trading_flag VARCHAR2(1) ;
189: --added for bug#6327274, start
190: v_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE;
191: lv_allow_shipment_wo_excise VARCHAR2(1);
192: -- bug#6327274, end
193: v_trad_register_code VARCHAR2(30) ;
194: v_item_trading_flag VARCHAR2(1) ;

Line 219: JAI_INV_SUBINV_DTLS

215: NVL(Location_id,0),
216: trading,
217: NVL(bonded,'N') bonded --added for bug#6327274
218: FROM
219: JAI_INV_SUBINV_DTLS
220: WHERE
221: Sub_Inventory_Name = v_subinventory AND
222: organization_id = v_organization_id ;
223:

Line 1505: FROM JAI_INV_SUBINV_DTLS

1501: AND Delivery_id = v_delivery_id; /* Added delivery_id by mmurtuza for bug 13885787*/
1502: CURSOR Location_Cursor IS
1503: SELECT NVL(Location_id,0),
1504: trading
1505: FROM JAI_INV_SUBINV_DTLS
1506: WHERE Sub_Inventory_Name = v_subinventory
1507: AND organization_id = v_organization_id;
1508: CURSOR get_ship_to_org_id_cur( p_line_id NUMBER) IS
1509: SELECT ship_to_org_id, invoice_to_org_id --added invoice_to_org_id for bug#8731696

Line 1620: FROM JAI_INV_SUBINV_DTLS A

1616: inventory_item_id = p_item_id;
1617:
1618: CURSOR bonded_cur(p_organization_id NUMBER, p_subinventory VARCHAR2) IS
1619: SELECT NVL(A.bonded,'Y') bonded
1620: FROM JAI_INV_SUBINV_DTLS A
1621: WHERE A.sub_inventory_name = p_subinventory
1622: AND A.organization_id = p_organization_id;
1623: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_order_type_id NUMBER) IS
1624: SELECT A.register_code