APPS.INV_TXN_MANAGER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 261: , mtl_system_items_b msi

257: , mti.kanban_card_id
258: , mti.transaction_mode --J-dev
259: FROM mtl_transactions_interface mti
260: , mtl_transaction_lots_interface mtli
261: , mtl_system_items_b msi
262: WHERE mti.transaction_interface_id = p_interface_id
263: AND mti.transaction_interface_id = mtli.transaction_interface_id
264: AND mti.organization_id = msi.organization_id
265: AND mti.inventory_item_id = msi.inventory_item_id

Line 815: FROM mtl_system_items

811: try copying everything from the parent MSNIs*/
812: BEGIN
813: SELECT serial_number_control_code
814: INTO l_serial_code
815: FROM mtl_system_items
816: WHERE inventory_item_id = l_mti_csr.inventory_item_id
817: AND organization_id = l_mti_csr.organization_id;
818:
819: IF (l_debug = 1)

Line 2112: MTL_SYSTEM_ITEMS MSI

2108: p_line_rec_type.TRANSFER_LOCATOR,
2109: p_line_rec_type.transaction_date,
2110: MP.NEGATIVE_INV_RECEIPT_CODE
2111: FROM MTL_PARAMETERS MP,
2112: MTL_SYSTEM_ITEMS MSI
2113: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2114: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2115: AND p_line_rec_type.PROCESS_FLAG = 1
2116: AND ((MSI.LOT_CONTROL_CODE = 1) OR (p_line_rec_type.transaction_source_type_id=5 and p_line_rec_type.wip_entity_type <> 10))--J-dev--verify this

Line 2156: MTL_SYSTEM_ITEMS MSI

2152: p_line_rec_type.transaction_date,
2153: MP.NEGATIVE_INV_RECEIPT_CODE
2154: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
2155: MTL_PARAMETERS MP,
2156: MTL_SYSTEM_ITEMS MSI
2157: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2158: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2159: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID
2160: AND p_line_rec_type.PROCESS_FLAG = 1

Line 4368: FROM MTL_SYSTEM_ITEMS

4364:
4365: BEGIN
4366: SELECT serial_number_control_code
4367: INTO l_serial_control
4368: FROM MTL_SYSTEM_ITEMS
4369: WHERE inventory_item_id= p_mmtt.inventory_item_id
4370: AND organization_id = p_mmtt.organization_id;
4371: EXCEPTION
4372: WHEN OTHERS THEN

Line 4995: FROM mtl_parameters mp, mtl_system_items msi

4991: )
4992: , p_line_rec_type.transfer_locator
4993: , p_line_rec_type.transaction_date
4994: , mp.negative_inv_receipt_code
4995: FROM mtl_parameters mp, mtl_system_items msi
4996: WHERE mp.organization_id = p_line_rec_type.organization_id
4997: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
4998: AND p_line_rec_type.process_flag = 1
4999: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'

Line 5040: , mtl_system_items msi

5036: , p_line_rec_type.transaction_date
5037: , mp.negative_inv_receipt_code
5038: FROM mtl_transaction_lots_interface mtli
5039: , mtl_parameters mp
5040: , mtl_system_items msi
5041: WHERE mp.organization_id = p_line_rec_type.organization_id
5042: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
5043: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'
5044: AND mtli.transaction_interface_id =

Line 5081: FROM mtl_system_items c

5077: )
5078: , a.transaction_source_name
5079: , a.transaction_date
5080: , a.content_lpn_id
5081: FROM mtl_system_items c
5082: , mtl_transaction_lots_temp b
5083: , mtl_material_transactions_temp a
5084: WHERE a.transaction_header_id = p_line_rec_type.transaction_header_id
5085: AND a.transaction_temp_id =

Line 5626: FROM mtl_system_items c

5622: , DECODE (a.process_flag, 'Y', 1, 'N', 2, 'E', 3, 3)
5623: , a.shippable_flag
5624: , b.transaction_temp_id --lot record identifier in MTLT
5625: , a.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
5626: FROM mtl_system_items c
5627: , mtl_transaction_lots_temp b
5628: , mtl_material_transactions_temp a
5629: WHERE a.transaction_header_id = p_header_id
5630: AND a.transaction_temp_id = p_transaction_temp_id

Line 6116: FROM mtl_system_items_b

6112: SELECT lot_control_code,
6113: revision_qty_control_code
6114: INTO l_lctrl,
6115: l_rctrl
6116: FROM mtl_system_items_b
6117: WHERE organization_id = l_org_id
6118: AND inventory_item_id = l_item_id;
6119: EXCEPTION
6120: WHEN NO_DATA_FOUND THEN