eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MOVPROC_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 485: mtl_system_items_kfv msik

481: mti.program_application_id,
482: mti.program_id,
483: mti.program_update_date
484: FROM mtl_transactions_interface mti,
485: mtl_system_items_kfv msik
486: WHERE mti.transaction_header_id = p_mtl_header_id
487: AND mti.inventory_item_id = msik.inventory_item_id
488: AND mti.organization_id = msik.organization_id
489: AND mti.error_explanation IS NOT NULL;

Line 5927: mtl_system_items msi,

5923: FROM /* bugfix 5129403: modified the order in the from clause */
5924: wip_move_txn_interface wmti,
5925: wip_operation_resources wor,
5926: bom_resources br,
5927: mtl_system_items msi,
5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
5930: bom_calendar_dates bcd4,
5931: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required

Line 6136: mtl_system_items msi,

6132: bom_departments bd,
6133: bom_calendar_dates bcd1,
6134: bom_calendar_dates bcd2,
6135: fnd_user fu,
6136: mtl_system_items msi,
6137: mtl_parameters mp,
6138: hr_organization_information hoi,
6139: wip_entities we,
6140: wip_repetitive_schedules wrs,

Line 6337: mtl_system_items msi,

6333: FROM /* bugfix 5129403: modified the order in the from clause */
6334: wip_move_txn_interface wmti,
6335: wip_operation_resources wor,
6336: bom_resources br,
6337: mtl_system_items msi,
6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6340: bom_calendar_dates bcd4,
6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required

Line 6564: mtl_system_items msi,

6560: bom_calendar_dates bcd1,
6561: bom_calendar_dates bcd2,
6562: fnd_user fu,
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,
6565: mtl_parameters mp,
6566: hr_organization_information hoi,
6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,

Line 8136: mtl_system_items msi,

8132: p_gib.mtl_header_id, -- transaction_batch_id
8133: wmti.qa_collection_id, /*Added for Bug 7136450 (FP of 7126588 )*/
8134: WIP_CONSTANTS.ASSY_BATCH_SEQ -- transaction_batch_seq
8135: FROM wip_move_txn_interface wmti,
8136: mtl_system_items msi,
8137: wip_discrete_jobs wdj
8138: WHERE wmti.group_id = p_gib.group_id
8139: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8140: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8270: mtl_system_items msi,

8266: 'Y', -- posting_flag
8267: p_gib.mtl_header_id, -- transaction_batch_id
8268: WIP_CONSTANTS.ASSY_BATCH_SEQ -- transaction_batch_seq
8269: FROM wip_move_txn_interface wmti,
8270: mtl_system_items msi,
8271: wip_repetitive_schedules wrs
8272: WHERE wmti.group_id = p_gib.group_id
8273: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8274: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8635: mtl_system_items msi,

8631: wmti.qa_collection_id
8632: FROM wip_move_txn_interface wmti,
8633: mtl_item_locations mil,
8634: wip_operations wop,
8635: mtl_system_items msi,
8636: wip_discrete_jobs wdj
8637: WHERE wmti.group_id = p_gib.group_id
8638: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8639: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8768: mtl_system_items msi,

8764: -- material processor need this value to enable quality
8765: wmti.qa_collection_id
8766: FROM wip_move_txn_interface wmti,
8767: wip_operations wop,
8768: mtl_system_items msi,
8769: wip_repetitive_schedules wrs,
8770: wip_repetitive_items wri
8771: WHERE wmti.group_id = p_gib.group_id
8772: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 8809: mtl_system_items msi

8805:
8806: SELECT COUNT(*)
8807: INTO l_mti_lot_rec
8808: FROM mtl_transactions_interface mti,
8809: mtl_system_items msi
8810: WHERE mti.organization_id = msi.organization_id
8811: AND mti.inventory_item_id = msi.inventory_item_id
8812: AND mti.transaction_header_id = p_gib.assy_header_id
8813: AND mti.transaction_action_id = l_txn_action_id

Line 8873: mtl_system_items msi,

8869: WIP_CONSTANTS.FULL_SN, mtl_material_transactions_s.nextval,
8870: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
8871: NULL)
8872: FROM mtl_transactions_interface mti,
8873: mtl_system_items msi,
8874: wip_discrete_jobs wdj
8875: WHERE mti.organization_id = msi.organization_id
8876: AND mti.inventory_item_id = msi.inventory_item_id
8877: AND mti.transaction_header_id = p_gib.assy_header_id

Line 8910: mtl_system_items msi,

8906: UPDATE mtl_transaction_lots_interface mtli
8907: SET lot_expiration_date =
8908: (SELECT MIN(mln.expiration_date)
8909: FROM mtl_transactions_interface mti,
8910: mtl_system_items msi,
8911: mtl_lot_numbers mln
8912: WHERE mti.organization_id = msi.organization_id
8913: AND mti.inventory_item_id = msi.inventory_item_id
8914: AND mti.transaction_header_id = p_gib.assy_header_id

Line 8927: mtl_system_items msi

8923: AND mln.organization_id = mti.organization_id)
8924: WHERE mtli.transaction_interface_id IN
8925: (SELECT mti.transaction_interface_id
8926: FROM mtl_transactions_interface mti,
8927: mtl_system_items msi
8928: WHERE mti.organization_id = msi.organization_id
8929: AND mti.inventory_item_id = msi.inventory_item_id
8930: AND mti.transaction_header_id = p_gib.assy_header_id
8931: AND mti.transaction_action_id = l_txn_action_id

Line 8956: mtl_system_items msi

8952: UPDATE mtl_transaction_lots_interface mtli
8953: SET lot_expiration_date =
8954: (SELECT mti.transaction_date + NVL(msi.shelf_life_days,0)
8955: FROM mtl_transactions_interface mti,
8956: mtl_system_items msi
8957: WHERE mti.transaction_header_id = p_gib.assy_header_id
8958: AND mti.transaction_action_id = l_txn_action_id
8959: AND mti.transaction_type_id = l_txn_type_id
8960: AND mti.transaction_source_type_id = TPS_INV_JOB_OR_SCHED

Line 8973: mtl_system_items msi

8969: WHERE mtli.lot_expiration_date IS NULL
8970: AND mtli.transaction_interface_id IN
8971: (SELECT mti.transaction_interface_id
8972: FROM mtl_transactions_interface mti,
8973: mtl_system_items msi
8974: WHERE mti.organization_id = msi.organization_id
8975: AND mti.inventory_item_id = msi.inventory_item_id
8976: AND mti.transaction_header_id = p_gib.assy_header_id
8977: AND mti.transaction_action_id = l_txn_action_id

Line 9000: mtl_system_items msi

8996:
8997: SELECT COUNT(*)
8998: INTO l_mti_ser_rec
8999: FROM mtl_transactions_interface mti,
9000: mtl_system_items msi
9001: WHERE mti.organization_id = msi.organization_id
9002: AND mti.inventory_item_id = msi.inventory_item_id
9003: AND mti.transaction_header_id = p_gib.assy_header_id
9004: AND mti.transaction_action_id = l_txn_action_id

Line 9045: mtl_system_items msi,

9041: mti.last_update_login,
9042: wsmi.assembly_serial_number,
9043: wsmi.assembly_serial_number
9044: FROM mtl_transactions_interface mti,
9045: mtl_system_items msi,
9046: mtl_transaction_lots_interface mtli,
9047: wip_serial_move_interface wsmi
9048: WHERE mti.organization_id = msi.organization_id
9049: AND mti.inventory_item_id = msi.inventory_item_id