APPS.INV_DIAG_MSN dependencies on MTL_SERIAL_NUMBERS

Line 66: 'FROM mtl_serial_numbers msn '||

62: ', TO_CHAR( msn.last_update_date, ''DD-MON-RR HH24:MI'' ) "Last|Updated" '||
63: ', msn.last_transaction_id "Last Transaction ID" '||
64: ', msn.wip_entity_id "WIP Entity ID" '||
65: ', msn.original_wip_entity_id "Original|WIP Entity ID" '||
66: 'FROM mtl_serial_numbers msn '||
67: ', mfg_lookups ml '||
68: 'WHERE 1 = 1 ';
69:
70: if l_org_id is not null then

Line 94: from mtl_serial_numbers

90: (serial_number
91: ,org_id
92: ,inventory_item_id)
93: select distinct serial_number, current_organization_id,inventory_item_id
94: from mtl_serial_numbers
95: where inventory_item_id = nvl(l_item_id, inventory_item_id)
96: and current_organization_id = nvl(l_org_id, current_organization_id)
97: and serial_number = nvl(l_sn, serial_number);
98: