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 119: mtl_material_transactions mmt

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

Line 152: mtl_material_transactions mmt

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

Line 188: FROM mtl_material_transactions

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

Line 1151: SELECT 'X' FROM mtl_material_transactions mmt

1147: AND nvl(msi.comms_nl_trackable_flag, 'N') = 'Y'
1148: AND (nvl(quantity_issued,0) > 0
1149: OR
1150: EXISTS (
1151: SELECT 'X' FROM mtl_material_transactions mmt
1152: WHERE mmt.transaction_action_id in (1,34)
1153: AND mmt.transaction_source_type_id = 5
1154: AND mmt.transaction_source_id = wip.wip_entity_id
1155: AND mmt.inventory_item_id = wip.inventory_item_id))

Line 1174: SELECT 'X' FROM mtl_material_transactions mmt

1170: AND nvl(quantity_per_assembly, 0) > 0
1171: AND (nvl(quantity_issued,0) > 0
1172: OR
1173: EXISTS (
1174: SELECT 'X' FROM mtl_material_transactions mmt
1175: WHERE mmt.transaction_action_id in (1,34)
1176: AND mmt.transaction_source_type_id = 5
1177: AND mmt.transaction_source_id = wip.wip_entity_id
1178: AND mmt.inventory_item_id = wip.inventory_item_id))

Line 1221: FROM mtl_material_transactions mmt

1217:
1218: IF l_requirements_tbl(l_ind).issued_quantity = 0 THEN
1219: SELECT sum(nvl(abs(transaction_quantity),0))
1220: INTO l_requirements_tbl(l_ind).issued_quantity
1221: FROM mtl_material_transactions mmt
1222: WHERE mmt.transaction_action_id in (1,34)
1223: AND mmt.transaction_source_type_id = 5
1224: AND mmt.inventory_item_id = l_requirements_tbl(l_ind).inventory_item_id
1225: AND mmt.transaction_source_id = p_wip_entity_id;

Line 1260: FROM mtl_material_transactions mmt

1256:
1257: IF l_requirements_tbl(l_ind).issued_quantity = 0 THEN
1258: SELECT sum(nvl(abs(transaction_quantity),0))
1259: INTO l_requirements_tbl(l_ind).issued_quantity
1260: FROM mtl_material_transactions mmt
1261: WHERE mmt.transaction_action_id in (1,34)
1262: AND mmt.transaction_source_type_id = 5
1263: AND mmt.inventory_item_id = l_requirements_tbl(l_ind).inventory_item_id
1264: AND mmt.transaction_source_id = p_wip_entity_id;

Line 3576: FROM mtl_material_transactions

3572:
3573: CURSOR issue_cur IS
3574: SELECT inventory_item_id,
3575: sum(abs(primary_quantity)) qty_issued
3576: FROM mtl_material_transactions
3577: WHERE transaction_action_id = 1
3578: AND transaction_source_type_id = 5
3579: AND transaction_source_id = p_wip_entity_id
3580: GROUP BY inventory_item_id;

Line 3719: FROM mtl_material_transactions

3715:
3716: CURSOR issue_cur IS
3717: SELECT inventory_item_id,
3718: sum(abs(primary_quantity)) qty_issued
3719: FROM mtl_material_transactions
3720: WHERE transaction_action_id = 1
3721: AND transaction_source_type_id = 5
3722: AND transaction_source_id = p_txn_ref.wip_entity_id
3723: GROUP BY inventory_item_id;

Line 3869: mtl_material_transactions mmt

3865:
3866: CURSOR mtl_txn_cur(p_migration_date IN date) IS
3867: SELECT transaction_id
3868: FROM mtl_system_items msi,
3869: mtl_material_transactions mmt
3870: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
3871: AND mmt.transaction_source_id = p_wip_entity_id
3872: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions
3873: AND mmt.creation_date < p_mtl_creation_date

Line 3944: FROM mtl_material_transactions

3940: l_csi_txn_found varchar2(1) := 'N';
3941:
3942: CURSOR issue_cur(pc_wip_entity_id in number) IS
3943: SELECT transaction_id
3944: FROM mtl_material_transactions
3945: WHERE transaction_source_type_id = 5
3946: AND transaction_action_id in (1, 34)
3947: AND transaction_source_id = pc_wip_entity_id;
3948:

Line 3951: FROM mtl_material_transactions

3947: AND transaction_source_id = pc_wip_entity_id;
3948:
3949: CURSOR compl_cur(pc_wip_entity_id in number) IS
3950: SELECT transaction_id
3951: FROM mtl_material_transactions
3952: WHERE transaction_action_id = 31
3953: AND transaction_source_type_id = 5
3954: AND transaction_source_id = pc_wip_entity_id;
3955:

Line 4200: FROM mtl_material_transactions mmt_assem,

4196: IF p_txn_ref.wip_entity_type = 4 THEN -- wo less completions
4197:
4198: SELECT nvl(mmt_assem.primary_quantity,0)
4199: INTO l_qty_completed
4200: FROM mtl_material_transactions mmt_assem,
4201: mtl_material_transactions mmt_comp
4202: WHERE mmt_assem.transaction_action_id = 31
4203: AND mmt_assem.transaction_source_type_id = 5
4204: AND mmt_comp.transaction_source_id = p_txn_ref.wip_entity_id

Line 4201: mtl_material_transactions mmt_comp

4197:
4198: SELECT nvl(mmt_assem.primary_quantity,0)
4199: INTO l_qty_completed
4200: FROM mtl_material_transactions mmt_assem,
4201: mtl_material_transactions mmt_comp
4202: WHERE mmt_assem.transaction_action_id = 31
4203: AND mmt_assem.transaction_source_type_id = 5
4204: AND mmt_comp.transaction_source_id = p_txn_ref.wip_entity_id
4205: AND mmt_comp.transaction_id = p_txn_ref.transaction_id

Line 4409: p_mmt_rec IN mtl_material_transactions%rowtype,

4405: x_return_status := fnd_api.g_ret_sts_error;
4406: END Delink_ReplaceRebuilds;
4407:
4408: PROCEDURE wip_issue(
4409: p_mmt_rec IN mtl_material_transactions%rowtype,
4410: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4411: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4412: x_return_status OUT NOCOPY varchar2)
4413: IS

Line 4573: l_mmt_rec mtl_material_transactions%rowtype;

4569: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4570: x_return_status OUT nocopy varchar2)
4571: IS
4572:
4573: l_mmt_rec mtl_material_transactions%rowtype;
4574: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4575: l_error_rec csi_datastructures_pub.transaction_error_rec;
4576: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4577:

Line 4619: FROM mtl_material_transactions

4615: l_csi_txn_rec.object_version_number := 1.0;
4616:
4617:
4618: SELECT * INTO l_mmt_rec
4619: FROM mtl_material_transactions
4620: WHERE transaction_id = p_transaction_id;
4621:
4622: wip_issue(
4623: p_mmt_rec => l_mmt_rec,

Line 4663: l_mmt_rec mtl_material_transactions%rowtype;

4659: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4660: x_return_status OUT nocopy varchar2)
4661: IS
4662:
4663: l_mmt_rec mtl_material_transactions%rowtype;
4664: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4665: l_error_rec csi_datastructures_pub.transaction_error_rec;
4666: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4667:

Line 4709: FROM mtl_material_transactions

4705: l_csi_txn_rec.object_version_number := 1.0;
4706:
4707:
4708: SELECT * INTO l_mmt_rec
4709: FROM mtl_material_transactions
4710: WHERE transaction_id = p_transaction_id;
4711:
4712: wip_issue(
4713: p_mmt_rec => l_mmt_rec,

Line 4756: l_mmt_rec mtl_material_transactions%rowtype;

4752: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4753: x_return_status OUT nocopy varchar2)
4754: IS
4755:
4756: l_mmt_rec mtl_material_transactions%rowtype;
4757: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4758: l_error_rec csi_datastructures_pub.transaction_error_rec;
4759: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4760:

Line 4802: FROM mtl_material_transactions

4798: l_csi_txn_rec.object_version_number := 1.0;
4799:
4800:
4801: SELECT * INTO l_mmt_rec
4802: FROM mtl_material_transactions
4803: WHERE transaction_id = p_transaction_id;
4804:
4805: wip_issue(
4806: p_mmt_rec => l_mmt_rec,

Line 4847: l_mmt_rec mtl_material_transactions%rowtype;

4843: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4844: x_return_status OUT nocopy varchar2)
4845: IS
4846:
4847: l_mmt_rec mtl_material_transactions%rowtype;
4848: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4849: l_error_rec csi_datastructures_pub.transaction_error_rec;
4850: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4851:

Line 4893: FROM mtl_material_transactions

4889: l_csi_txn_rec.object_version_number := 1.0;
4890:
4891:
4892: SELECT * INTO l_mmt_rec
4893: FROM mtl_material_transactions
4894: WHERE transaction_id = p_transaction_id;
4895:
4896: wip_issue(
4897: p_mmt_rec => l_mmt_rec,

Line 5513: FROM mtl_material_transactions mmt,

5509: CURSOR parent_item_csr (p_transaction_set_id IN NUMBER) IS
5510: SELECT mmt.inventory_item_id inventory_item_id,
5511: mut.serial_number serial_number
5512: --INTO l_inv_item_id, l_serial_number
5513: FROM mtl_material_transactions mmt,
5514: mtl_unit_transactions mut
5515: WHERE mmt.transaction_id = mut.transaction_id
5516: AND mmt.transaction_set_id = p_transaction_set_id
5517: AND mmt.transaction_type_id = 17;

Line 5685: from mtl_material_transactions mmt, mtl_unit_transactions mut

5681: --Added for bug 5376024--
5682: /* BEGIN
5683: select mmt.inventory_item_id, mut.serial_number
5684: into l_inv_item_id, l_serial_number
5685: from mtl_material_transactions mmt, mtl_unit_transactions mut
5686: where mmt.transaction_id = mut.transaction_id
5687: and mmt.transaction_set_id = p_mmt_rec.transaction_set_id
5688: and mmt.transaction_type_id = 17;
5689:

Line 6914: mtl_material_transactions mmt

6910: IS
6911: CURSOR mtl_txn_cur(p_wip_entity_id IN number, p_migration_date IN date) IS
6912: SELECT transaction_id
6913: FROM mtl_system_items msi,
6914: mtl_material_transactions mmt
6915: WHERE mmt.transaction_source_type_id = 5 -- job/schedule transactions
6916: AND mmt.transaction_source_id = p_wip_entity_id
6917: AND mmt.transaction_action_id in (1, 27, 31, 32, 33, 34) -- ib handled wip actions
6918: AND mmt.transaction_date > p_migration_date