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.CSI_WIP_TRXS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 118: mtl_material_transactions mmt

114: FROM hr_all_organization_units haou,
115: mtl_transaction_lot_numbers mtln,
116: mtl_unit_transactions mut,
117: mtl_secondary_inventories msi,
118: mtl_material_transactions mmt
119: WHERE mmt.transaction_id = p_transaction_id
120: AND mmt.transaction_id = mut.transaction_id(+)
121: AND mmt.transaction_id = mtln.transaction_id(+)
122: AND mmt.subinventory_code = msi.secondary_inventory_name

Line 151: mtl_material_transactions mmt

147: FROM hr_all_organization_units haou,
148: mtl_transaction_lot_numbers mtln,
149: mtl_unit_transactions mut,
150: mtl_secondary_inventories msi,
151: mtl_material_transactions mmt
152: WHERE mmt.transaction_id = p_transaction_id
153: AND mmt.subinventory_code = msi.secondary_inventory_name
154: AND mmt.organization_id = msi.organization_id
155: AND mtln.transaction_id = mmt.transaction_id

Line 187: FROM mtl_material_transactions

183: l_txn_ref.transaction_source_type_id,
184: l_txn_ref.transaction_action_id,
185: l_txn_ref.wip_entity_id,
186: l_txn_ref.creation_date
187: FROM mtl_material_transactions
188: WHERE transaction_id = p_transaction_id;
189:
190: SELECT master_organization_id
191: INTO l_txn_ref.master_organization_id

Line 1131: SELECT 'X' FROM mtl_material_transactions mmt

1127: AND nvl(msi.comms_nl_trackable_flag, 'N') = 'Y'
1128: AND (nvl(quantity_issued,0) > 0
1129: OR
1130: EXISTS (
1131: SELECT 'X' FROM mtl_material_transactions mmt
1132: WHERE mmt.transaction_action_id in (1,34)
1133: AND mmt.transaction_source_type_id = 5
1134: AND mmt.transaction_source_id = wip.wip_entity_id
1135: AND mmt.inventory_item_id = wip.inventory_item_id))

Line 1154: SELECT 'X' FROM mtl_material_transactions mmt

1150: AND nvl(quantity_per_assembly, 0) > 0
1151: AND (nvl(quantity_issued,0) > 0
1152: OR
1153: EXISTS (
1154: SELECT 'X' FROM mtl_material_transactions mmt
1155: WHERE mmt.transaction_action_id in (1,34)
1156: AND mmt.transaction_source_type_id = 5
1157: AND mmt.transaction_source_id = wip.wip_entity_id
1158: AND mmt.inventory_item_id = wip.inventory_item_id))

Line 1201: FROM mtl_material_transactions mmt

1197:
1198: IF l_requirements_tbl(l_ind).issued_quantity = 0 THEN
1199: SELECT sum(nvl(abs(transaction_quantity),0))
1200: INTO l_requirements_tbl(l_ind).issued_quantity
1201: FROM mtl_material_transactions mmt
1202: WHERE mmt.transaction_action_id in (1,34)
1203: AND mmt.transaction_source_type_id = 5
1204: AND mmt.inventory_item_id = l_requirements_tbl(l_ind).inventory_item_id
1205: AND mmt.transaction_source_id = p_wip_entity_id;

Line 1240: FROM mtl_material_transactions mmt

1236:
1237: IF l_requirements_tbl(l_ind).issued_quantity = 0 THEN
1238: SELECT sum(nvl(abs(transaction_quantity),0))
1239: INTO l_requirements_tbl(l_ind).issued_quantity
1240: FROM mtl_material_transactions mmt
1241: WHERE mmt.transaction_action_id in (1,34)
1242: AND mmt.transaction_source_type_id = 5
1243: AND mmt.inventory_item_id = l_requirements_tbl(l_ind).inventory_item_id
1244: AND mmt.transaction_source_id = p_wip_entity_id;

Line 3447: FROM mtl_material_transactions

3443:
3444: CURSOR issue_cur IS
3445: SELECT inventory_item_id,
3446: sum(abs(primary_quantity)) qty_issued
3447: FROM mtl_material_transactions
3448: WHERE transaction_action_id = 1
3449: AND transaction_source_type_id = 5
3450: AND transaction_source_id = p_wip_entity_id
3451: GROUP BY inventory_item_id;

Line 3590: FROM mtl_material_transactions

3586:
3587: CURSOR issue_cur IS
3588: SELECT inventory_item_id,
3589: sum(abs(primary_quantity)) qty_issued
3590: FROM mtl_material_transactions
3591: WHERE transaction_action_id = 1
3592: AND transaction_source_type_id = 5
3593: AND transaction_source_id = p_txn_ref.wip_entity_id
3594: GROUP BY inventory_item_id;

Line 3740: mtl_material_transactions mmt

3736:
3737: CURSOR mtl_txn_cur(p_migration_date IN date) IS
3738: SELECT transaction_id
3739: FROM mtl_system_items msi,
3740: mtl_material_transactions mmt
3741: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
3742: AND mmt.transaction_source_id = p_wip_entity_id
3743: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions
3744: AND mmt.creation_date < p_mtl_creation_date

Line 3809: FROM mtl_material_transactions

3805: l_csi_txn_found varchar2(1) := 'N';
3806:
3807: CURSOR issue_cur(pc_wip_entity_id in number) IS
3808: SELECT transaction_id
3809: FROM mtl_material_transactions
3810: WHERE transaction_source_type_id = 5
3811: AND transaction_action_id in (1, 34)
3812: AND transaction_source_id = pc_wip_entity_id;
3813:

Line 3816: FROM mtl_material_transactions

3812: AND transaction_source_id = pc_wip_entity_id;
3813:
3814: CURSOR compl_cur(pc_wip_entity_id in number) IS
3815: SELECT transaction_id
3816: FROM mtl_material_transactions
3817: WHERE transaction_action_id = 31
3818: AND transaction_source_type_id = 5
3819: AND transaction_source_id = pc_wip_entity_id;
3820:

Line 4065: FROM mtl_material_transactions mmt_assem,

4061: IF p_txn_ref.wip_entity_type = 4 THEN -- wo less completions
4062:
4063: SELECT nvl(mmt_assem.primary_quantity,0)
4064: INTO l_qty_completed
4065: FROM mtl_material_transactions mmt_assem,
4066: mtl_material_transactions mmt_comp
4067: WHERE mmt_assem.transaction_action_id = 31
4068: AND mmt_assem.transaction_source_type_id = 5
4069: AND mmt_comp.transaction_source_id = p_txn_ref.wip_entity_id

Line 4066: mtl_material_transactions mmt_comp

4062:
4063: SELECT nvl(mmt_assem.primary_quantity,0)
4064: INTO l_qty_completed
4065: FROM mtl_material_transactions mmt_assem,
4066: mtl_material_transactions mmt_comp
4067: WHERE mmt_assem.transaction_action_id = 31
4068: AND mmt_assem.transaction_source_type_id = 5
4069: AND mmt_comp.transaction_source_id = p_txn_ref.wip_entity_id
4070: AND mmt_comp.transaction_id = p_txn_ref.transaction_id

Line 4274: p_mmt_rec IN mtl_material_transactions%rowtype,

4270: x_return_status := fnd_api.g_ret_sts_error;
4271: END Delink_ReplaceRebuilds;
4272:
4273: PROCEDURE wip_issue(
4274: p_mmt_rec IN mtl_material_transactions%rowtype,
4275: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4276: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4277: x_return_status OUT NOCOPY varchar2)
4278: IS

Line 4438: l_mmt_rec mtl_material_transactions%rowtype;

4434: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4435: x_return_status OUT nocopy varchar2)
4436: IS
4437:
4438: l_mmt_rec mtl_material_transactions%rowtype;
4439: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4440: l_error_rec csi_datastructures_pub.transaction_error_rec;
4441: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4442:

Line 4484: FROM mtl_material_transactions

4480: l_csi_txn_rec.object_version_number := 1.0;
4481:
4482:
4483: SELECT * INTO l_mmt_rec
4484: FROM mtl_material_transactions
4485: WHERE transaction_id = p_transaction_id;
4486:
4487: wip_issue(
4488: p_mmt_rec => l_mmt_rec,

Line 4528: l_mmt_rec mtl_material_transactions%rowtype;

4524: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4525: x_return_status OUT nocopy varchar2)
4526: IS
4527:
4528: l_mmt_rec mtl_material_transactions%rowtype;
4529: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4530: l_error_rec csi_datastructures_pub.transaction_error_rec;
4531: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4532:

Line 4574: FROM mtl_material_transactions

4570: l_csi_txn_rec.object_version_number := 1.0;
4571:
4572:
4573: SELECT * INTO l_mmt_rec
4574: FROM mtl_material_transactions
4575: WHERE transaction_id = p_transaction_id;
4576:
4577: wip_issue(
4578: p_mmt_rec => l_mmt_rec,

Line 4621: l_mmt_rec mtl_material_transactions%rowtype;

4617: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4618: x_return_status OUT nocopy varchar2)
4619: IS
4620:
4621: l_mmt_rec mtl_material_transactions%rowtype;
4622: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4623: l_error_rec csi_datastructures_pub.transaction_error_rec;
4624: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4625:

Line 4667: FROM mtl_material_transactions

4663: l_csi_txn_rec.object_version_number := 1.0;
4664:
4665:
4666: SELECT * INTO l_mmt_rec
4667: FROM mtl_material_transactions
4668: WHERE transaction_id = p_transaction_id;
4669:
4670: wip_issue(
4671: p_mmt_rec => l_mmt_rec,

Line 4712: l_mmt_rec mtl_material_transactions%rowtype;

4708: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4709: x_return_status OUT nocopy varchar2)
4710: IS
4711:
4712: l_mmt_rec mtl_material_transactions%rowtype;
4713: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4714: l_error_rec csi_datastructures_pub.transaction_error_rec;
4715: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4716:

Line 4758: FROM mtl_material_transactions

4754: l_csi_txn_rec.object_version_number := 1.0;
4755:
4756:
4757: SELECT * INTO l_mmt_rec
4758: FROM mtl_material_transactions
4759: WHERE transaction_id = p_transaction_id;
4760:
4761: wip_issue(
4762: p_mmt_rec => l_mmt_rec,

Line 5495: from mtl_material_transactions mmt, mtl_unit_transactions mut

5491: --Added for bug 5376024--
5492: BEGIN
5493: select mmt.inventory_item_id, mut.serial_number
5494: into l_inv_item_id, l_serial_number
5495: from mtl_material_transactions mmt, mtl_unit_transactions mut
5496: where mmt.transaction_id = mut.transaction_id
5497: and mmt.transaction_set_id = p_mmt_rec.transaction_set_id
5498: and mmt.transaction_type_id = 17;
5499:

Line 6708: mtl_material_transactions mmt

6704: IS
6705: CURSOR mtl_txn_cur(p_wip_entity_id IN number, p_migration_date IN date) IS
6706: SELECT transaction_id
6707: FROM mtl_system_items msi,
6708: mtl_material_transactions mmt
6709: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
6710: AND mmt.transaction_source_id = p_wip_entity_id
6711: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions
6712: AND mmt.transaction_date > p_migration_date