DBA Data[Home] [Help]

APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 3599: FROM JAI_INV_SUBINV_DTLS

3595: WHERE location_id = cp_location_id;
3596:
3597: CURSOR c_loc_linked_to_org_subinv(cp_organization_id IN NUMBER, cp_subinventory IN VARCHAR2) IS
3598: SELECT location_id, decode(bonded, 'Y', 'B', decode(trading, 'Y', 'T', 'N')) loc_subinventory_type
3599: FROM JAI_INV_SUBINV_DTLS
3600: WHERE organization_id = cp_organization_id
3601: AND sub_inventory_name = cp_subinventory;
3602:
3603: CURSOR c_base_subinv_dtls(cp_organization_id IN NUMBER, cp_subinventory IN VARCHAR2) IS