DBA Data[Home] [Help]

APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 3132: FROM JAI_INV_SUBINV_DTLS

3128: WHERE location_id = cp_location_id;
3129:
3130: CURSOR c_loc_linked_to_org_subinv(cp_organization_id IN NUMBER, cp_subinventory IN VARCHAR2) IS
3131: SELECT location_id, decode(bonded, 'Y', 'B', decode(trading, 'Y', 'T', 'N')) loc_subinventory_type
3132: FROM JAI_INV_SUBINV_DTLS
3133: WHERE organization_id = cp_organization_id
3134: AND sub_inventory_name = cp_subinventory;
3135:
3136: CURSOR c_base_subinv_dtls(cp_organization_id IN NUMBER, cp_subinventory IN VARCHAR2) IS