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 2125: MTL_SYSTEM_ITEMS MSI

2121: p_line_rec_type.TRANSFER_LOCATOR,
2122: p_line_rec_type.transaction_date,
2123: MP.NEGATIVE_INV_RECEIPT_CODE
2124: FROM MTL_PARAMETERS MP,
2125: MTL_SYSTEM_ITEMS MSI
2126: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2127: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2128: AND p_line_rec_type.PROCESS_FLAG = 1
2129: 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 2172: MTL_SYSTEM_ITEMS MSI

2168: p_line_rec_type.transaction_date,
2169: MP.NEGATIVE_INV_RECEIPT_CODE
2170: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
2171: MTL_PARAMETERS MP,
2172: MTL_SYSTEM_ITEMS MSI
2173: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2174: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
2175: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID
2176: AND p_line_rec_type.PROCESS_FLAG = 1

Line 4509: FROM MTL_SYSTEM_ITEMS

4505:
4506: BEGIN
4507: SELECT serial_number_control_code
4508: INTO l_serial_control
4509: FROM MTL_SYSTEM_ITEMS
4510: WHERE inventory_item_id= p_mmtt.inventory_item_id
4511: AND organization_id = p_mmtt.organization_id;
4512: EXCEPTION
4513: WHEN OTHERS THEN

Line 5136: FROM mtl_parameters mp, mtl_system_items msi

5132: )
5133: , p_line_rec_type.transfer_locator
5134: , p_line_rec_type.transaction_date
5135: , mp.negative_inv_receipt_code
5136: FROM mtl_parameters mp, mtl_system_items msi
5137: WHERE mp.organization_id = p_line_rec_type.organization_id
5138: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
5139: AND p_line_rec_type.process_flag = 1
5140: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'

Line 5181: , mtl_system_items msi

5177: , p_line_rec_type.transaction_date
5178: , mp.negative_inv_receipt_code
5179: FROM mtl_transaction_lots_interface mtli
5180: , mtl_parameters mp
5181: , mtl_system_items msi
5182: WHERE mp.organization_id = p_line_rec_type.organization_id
5183: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2
5184: -- AND p_line_rec_type.SHIPPABLE_FLAG='Y'
5185: AND mtli.transaction_interface_id =

Line 5222: FROM mtl_system_items c

5218: )
5219: , a.transaction_source_name
5220: , a.transaction_date
5221: , a.content_lpn_id
5222: FROM mtl_system_items c
5223: , mtl_transaction_lots_temp b
5224: , mtl_material_transactions_temp a
5225: WHERE a.transaction_header_id = p_line_rec_type.transaction_header_id
5226: AND a.transaction_temp_id =

Line 5822: FROM mtl_system_items c

5818: , DECODE (a.process_flag, 'Y', 1, 'N', 2, 'E', 3, 3)
5819: , a.shippable_flag
5820: , b.transaction_temp_id --lot record identifier in MTLT
5821: , a.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
5822: FROM mtl_system_items c
5823: , mtl_transaction_lots_temp b
5824: , mtl_material_transactions_temp a
5825: WHERE a.transaction_header_id = p_header_id
5826: AND a.transaction_temp_id = p_transaction_temp_id

Line 6312: FROM mtl_system_items_b

6308: SELECT lot_control_code,
6309: revision_qty_control_code
6310: INTO l_lctrl,
6311: l_rctrl
6312: FROM mtl_system_items_b
6313: WHERE organization_id = l_org_id
6314: AND inventory_item_id = l_item_id;
6315: EXCEPTION
6316: WHEN NO_DATA_FOUND THEN