APPS.WMS_CARTNZN_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 105: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp

101:
102: SUBTYPE MMTT_ROW_TYPE IS MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
103:
104: -- Table that needs to be passed inv_rcv_common_apis for splitting
105: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
106:
107: api_table inv_rcv_common_apis.trans_rec_tb_tp;
108:
109: -- This value is incremented and inserted into sequence_id of the table

Line 1927: mtl_serial_numbers_temp msnt,

1923:
1924: CURSOR serials(p_temp_id NUMBER, p_org_id NUMBER, p_item_id NUMBER) is
1925: SELECT msn.serial_number
1926: FROM
1927: mtl_serial_numbers_temp msnt,
1928: mtl_serial_numbers msn
1929: WHERE
1930: msnt.transaction_temp_id = p_temp_id AND
1931: msn.current_organization_id = p_org_id AND

Line 5409: mtl_serial_numbers_temp msnt

5405: mtlt.transaction_quantity lot_qty,
5406: msnt.fm_serial_number ser_num
5407: FROM mtl_material_transactions_temp mmtt,
5408: mtl_transaction_lots_temp mtlt,
5409: mtl_serial_numbers_temp msnt
5410: WHERE
5411: mmtt.transaction_temp_id = p_transaction_temp_id
5412: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
5413: AND mmtt.transaction_temp_id = msnt.transaction_temp_id(+)

Line 5693: mtl_serial_numbers_temp msnt

5689: mtlt.transaction_quantity lot_qty,
5690: msnt.fm_serial_number ser_num
5691: FROM mtl_material_transactions_temp mmtt,
5692: mtl_transaction_lots_temp mtlt,
5693: mtl_serial_numbers_temp msnt
5694: WHERE
5695: mmtt.transaction_temp_id = p_transaction_temp_id
5696: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
5697: AND mmtt.transaction_temp_id = msnt.transaction_temp_id(+)