DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_SECONDARY_INVENTORIES

Line 8102: FROM mtl_secondary_inventories msub,

8098: END IF;
8099:
8100: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
8101: INTO x_subinventory
8102: FROM mtl_secondary_inventories msub,
8103: mtl_system_items msi
8104: WHERE msub.secondary_inventory_name = x_cascaded_table(n).subinventory
8105: AND msub.organization_id = x_cascaded_table(n).to_organization_id
8106: AND x_cascaded_table(n).transaction_date < NVL(msub.disable_date, x_cascaded_table(n).transaction_date + 1)