DBA Data[Home] [Help]

APPS.CSI_RMA_FULFILL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 299: FROM mtl_system_items

295: l_error_rec.src_lot_ctrl_code ,
296: l_error_rec.src_rev_qty_ctrl_code,
297: l_error_rec.src_location_ctrl_code,
298: l_error_rec.comms_nl_trackable_flag
299: FROM mtl_system_items
300: WHERE inventory_item_id = l_rma_line_rec.inventory_item_id
301: AND organization_id = l_orgn_id;
302: Exception when others then
303: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');

Line 1221: from mtl_system_items_b

1217:
1218: Begin
1219: Select serial_number_control_code
1220: into l_item_srl_code
1221: from mtl_system_items_b
1222: where inventory_item_id = l_txn_line_dtl_rec.inventory_item_id
1223: and organization_id = l_dest_location_rec.inv_organization_id;--l_txn_line_dtl_rec.inv_organization_id;
1224: -- bug 3230999. since OM is always passing master inv.
1225: Exception when others Then