[Home] [Help]
3100: WHERE shipment_header_id = cp_shipment_header_id;
3101:
3102: CURSOR c_loc_item_dtls(cp_organization_id IN NUMBER, cp_inventory_item_id IN NUMBER) IS
3103: SELECT item_class, modvat_flag, excise_flag, item_trading_flag
3104: FROM JAI_INV_ITM_SETUPS
3105: WHERE organization_id = cp_organization_id
3106: AND inventory_item_id = cp_inventory_item_id;
3107:
3108: CURSOR c_base_item_dtls(cp_organization_id IN NUMBER, cp_inventory_item_id IN NUMBER) IS