DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_SECONDARY_INVENTORIES

Line 7258: FROM mtl_secondary_inventories msub,

7254: END IF;
7255:
7256: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
7257: INTO x_subinventory
7258: FROM mtl_secondary_inventories msub,
7259: mtl_system_items msi
7260: WHERE msub.secondary_inventory_name = x_cascaded_table(n).subinventory
7261: AND msub.organization_id = x_cascaded_table(n).to_organization_id
7262: AND x_cascaded_table(n).transaction_date < NVL(msub.disable_date, x_cascaded_table(n).transaction_date + 1)