DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 429: FROM JAI_INV_SUBINV_DTLS

425: /*lv_enable_gst_flag VARCHAR2(3);*/
426:
427: CURSOR Location_Cursor IS
428: SELECT Location_id
429: FROM JAI_INV_SUBINV_DTLS
430: WHERE Sub_Inventory_Name = lv_subinventory
431: AND organization_id = v_warehouse_id;
432: --added by peng.zheng for bug 10043656, ends
433:

Line 4358: FROM JAI_INV_SUBINV_DTLS

4354:
4355: CURSOR Location_Cursor IS
4356: SELECT Location_id
4357: , trading
4358: FROM JAI_INV_SUBINV_DTLS
4359: WHERE Sub_Inventory_Name = lv_subinventory
4360: AND organization_id = ln_organization_Id;
4361:
4362: CURSOR cur_chk_vat_exists (cp_order_line_id JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE)