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 1193: from mtl_system_items_b

1189:
1190: Begin
1191: Select serial_number_control_code
1192: into l_item_srl_code
1193: from mtl_system_items_b
1194: where inventory_item_id = l_txn_line_dtl_rec.inventory_item_id
1195: and organization_id = l_dest_location_rec.inv_organization_id;--l_txn_line_dtl_rec.inv_organization_id;
1196: -- bug 3230999. since OM is always passing master inv.
1197: Exception when others Then