DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_SECONDARY_INVENTORIES

Line 1173: FROM mtl_secondary_inventories msub,

1169: x_progress := '010';
1170:
1171: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
1172: INTO x_subinventory
1173: FROM mtl_secondary_inventories msub,
1174: mtl_system_items msi
1175: WHERE msub.secondary_inventory_name = x_subinventory_record.subinventory
1176: AND msub.organization_id = x_subinventory_record.to_organization_id
1177: AND x_subinventory_record.transaction_date < NVL(msub.disable_date, x_subinventory_record.transaction_date + 1)