DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 208: FROM JAI_INV_SUBINV_DTLS A

204: a.header_id = cp_order_header_id ;
205:
206: CURSOR bonded_cur(p_organization_id NUMBER, p_subinventory VARCHAR2) IS
207: SELECT NVL(A.bonded,'Y') bonded,NVL(A.trading,'Y') trading
208: FROM JAI_INV_SUBINV_DTLS A
209: WHERE A.sub_inventory_name = p_subinventory
210: AND A.organization_id = p_organization_id;
211:
212: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS