APPS.WMS_CARTNZN_PUB dependencies on MTL_SERIAL_NUMBERS

Line 181: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp

177: t_lpn_alloc_flag_table lpn_alloc_flag_tb;
178:
179:
180: -- Table that needs to be passed inv_rcv_common_apis for splitting
181: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
182:
183: api_table inv_rcv_common_apis.trans_rec_tb_tp;
184:
185: -- This value is incremented and inserted into sequence_id of the table

Line 2018: mtl_serial_numbers_temp msnt,

2014:
2015: CURSOR serials(p_temp_id NUMBER, p_org_id NUMBER, p_item_id NUMBER) is
2016: SELECT msn.serial_number
2017: FROM
2018: mtl_serial_numbers_temp msnt,
2019: mtl_serial_numbers msn
2020: WHERE
2021: msnt.transaction_temp_id = p_temp_id AND
2022: msn.current_organization_id = p_org_id AND

Line 2019: mtl_serial_numbers msn

2015: CURSOR serials(p_temp_id NUMBER, p_org_id NUMBER, p_item_id NUMBER) is
2016: SELECT msn.serial_number
2017: FROM
2018: mtl_serial_numbers_temp msnt,
2019: mtl_serial_numbers msn
2020: WHERE
2021: msnt.transaction_temp_id = p_temp_id AND
2022: msn.current_organization_id = p_org_id AND
2023: msn.inventory_item_id = p_item_id AND

Line 5383: mtl_serial_numbers_temp msnt

5379: mtlt.transaction_quantity lot_qty,
5380: msnt.fm_serial_number ser_num
5381: FROM mtl_material_transactions_temp mmtt,
5382: mtl_transaction_lots_temp mtlt,
5383: mtl_serial_numbers_temp msnt
5384: WHERE
5385: mmtt.transaction_temp_id = p_transaction_temp_id
5386: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
5387: AND mmtt.transaction_temp_id = msnt.transaction_temp_id(+)

Line 5657: mtl_serial_numbers_temp msnt

5653: mtlt.transaction_quantity lot_qty,
5654: msnt.fm_serial_number ser_num
5655: FROM mtl_material_transactions_temp mmtt,
5656: mtl_transaction_lots_temp mtlt,
5657: mtl_serial_numbers_temp msnt
5658: WHERE
5659: mmtt.transaction_temp_id = p_transaction_temp_id
5660: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
5661: AND mmtt.transaction_temp_id = msnt.transaction_temp_id(+)