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.

[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS

Line 287: from mtl_material_transactions_temp mmtt,

283: msi.mtl_transactions_enabled_flag,
284: msi.serial_number_control_code,
285: msi.lot_control_code,
286: mmtt.revision
287: from mtl_material_transactions_temp mmtt,
288: mtl_system_items_kfv msi,
289: mtl_transaction_lots_temp mtlt
290: where mmtt.completion_transaction_id = p_cplTxnID
291: and mmtt.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 330: from mtl_material_transactions_temp mmtt,

326: msi.mtl_transactions_enabled_flag,
327: msi.serial_number_control_code,
328: msi.lot_control_code,
329: mmtt.revision
330: from mtl_material_transactions_temp mmtt,
331: mtl_system_items_kfv msi,
332: mtl_transaction_lots_temp mtlt
333: where mmtt.move_transaction_id = p_movTxnID
334: and mmtt.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 753: from mtl_material_transactions_temp mti,

749: msi.mtl_transactions_enabled_flag,
750: msi.serial_number_control_code,
751: msi.lot_control_code,
752: mti.revision
753: from mtl_material_transactions_temp mti,
754: mtl_system_items_kfv msi,
755: mtl_transaction_lots_temp mtlt
756: where mti.move_transaction_id = p_movTxnID
757: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 1070: mtl_material_transactions mmt,

1066: select tln.lot_number,
1067: max(mln.expiration_date),
1068: abs(round(sum(tln.primary_quantity), wip_constants.max_displayed_precision))
1069: from mtl_transaction_lot_numbers tln,
1070: mtl_material_transactions mmt,
1071: mtl_lot_numbers mln
1072: where tln.organization_id = p_orgID
1073: and tln.transaction_source_id = p_wipEntityID
1074: and tln.transaction_source_type_id = 5

Line 1093: mtl_material_transactions mmt,

1089: select tln.lot_number,
1090: max(mln.expiration_date),
1091: abs(round(sum(tln.primary_quantity), wip_constants.max_displayed_precision))
1092: from mtl_transaction_lot_numbers tln,
1093: mtl_material_transactions mmt,
1094: mtl_lot_numbers mln
1095: where tln.organization_id = p_orgID
1096: and tln.transaction_source_id = p_wipEntityID
1097: and tln.transaction_source_type_id = 5

Line 1356: from mtl_material_transactions

1352: mtl_lot_numbers mln ,
1353: mtl_onhand_quantities_detail moq
1354: where tln.transaction_date =
1355: ( select max(transaction_date)
1356: from mtl_material_transactions
1357: where organization_id = p_OrgID
1358: and transaction_source_id =p_wipEntityID
1359: and transaction_source_type_id = 5
1360: and inventory_item_id = v_ItemId

Line 2359: mtl_material_transactions mmt,

2355:
2356: SELECT mtln.lot_number lot,
2357: mtln.primary_quantity * -1 lot_qty
2358: FROM mtl_object_genealogy mog,
2359: mtl_material_transactions mmt,
2360: mtl_transaction_lot_numbers mtln,
2361: mtl_lot_numbers mln
2362: WHERE mog.object_id = mln.gen_object_id
2363: AND mog.end_date_active IS NULL

Line 2483: mtl_material_transactions mmt,

2479: CURSOR c_revisionComp IS
2480:
2481: SELECT mmt.revision revision
2482: FROM mtl_object_genealogy mog,
2483: mtl_material_transactions mmt,
2484: mtl_transaction_lot_numbers mtln,
2485: mtl_lot_numbers mln
2486: WHERE mog.object_id = mln.gen_object_id
2487: AND mog.end_date_active IS NULL