40: v_organization_id NUMBER;
41: v_subinventory VARCHAR2(10);
42: v_source_header_type_id NUMBER;
43: v_trading_flag VARCHAR2(1);
44: v_bonded JAI_INV_SUBINV_DTLS.bonded%TYPE;
45: lv_allow_shipment_wo_excise VARCHAR2(1);
46: v_trad_register_code VARCHAR2(30);
47: v_location_id NUMBER;
48: v_exe_flag VARCHAR2(150);
64: NVL(Location_id,0),
65: trading,
66: NVL(bonded,'N') bonded
67: FROM
68: JAI_INV_SUBINV_DTLS
69: WHERE
70: Sub_Inventory_Name = v_subinventory AND
71: organization_id = v_organization_id;
72: