DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on MTL_ITEM_LOC_DEFAULTS

Line 207: FROM mtl_item_loc_defaults mld,

203:
204: BEGIN
205: SELECT mld.locator_id
206: INTO x_cascaded_table(n).locator_id
207: FROM mtl_item_loc_defaults mld,
208: mtl_item_locations mil
209: WHERE mld.inventory_item_id = x_cascaded_table(n).item_id
210: AND mld.organization_id = x_cascaded_table(n).to_organization_id
211: AND mld.subinventory_code = x_cascaded_table(n).subinventory

Line 255: FROM mtl_item_loc_defaults mld,

251: l_segmentarray(7), l_segmentarray(8), l_segmentarray(9),
252: l_segmentarray(10), l_segmentarray(11), l_segmentarray(12),
253: l_segmentarray(13), l_segmentarray(14), l_segmentarray(15),
254: l_segmentarray(16), l_segmentarray(17), l_segmentarray(18)
255: FROM mtl_item_loc_defaults mld,
256: mtl_item_locations mil
257: WHERE mld.inventory_item_id = x_cascaded_table(n).item_id
258: AND mld.organization_id = x_cascaded_table(n).to_organization_id
259: AND mld.subinventory_code = x_cascaded_table(n).subinventory