DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 203: FROM JAI_INV_SUBINV_DTLS A

199: a.header_id = cp_order_header_id ;
200:
201: CURSOR bonded_cur(p_organization_id NUMBER, p_subinventory VARCHAR2) IS
202: SELECT NVL(A.bonded,'Y') bonded,NVL(A.trading,'Y') trading
203: FROM JAI_INV_SUBINV_DTLS A
204: WHERE A.sub_inventory_name = p_subinventory
205: AND A.organization_id = p_organization_id;
206:
207: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS