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

Line 97: FROM mtl_material_transactions mmt

93: mmt.primary_quantity
94: INTO l_transaction_action_id,
95: l_transaction_source_type_id,
96: l_primary_quantity
97: FROM mtl_material_transactions mmt
98: WHERE mmt.transaction_id = p_txn_id;
99:
100: ------------------------------------------------------------
101: -- In case Asembly Returns cancels Assembly completions then

Line 1833: FROM mtl_material_transactions mmt

1829: ------------------------------------------------
1830: l_stmt_num := 110;
1831: SELECT sum(primary_quantity)
1832: INTO l_assembly_return_cnt
1833: FROM mtl_material_transactions mmt
1834: WHERE mmt.transaction_source_id = p_entity_id
1835: AND mmt.transaction_action_id = 32
1836: AND mmt.transaction_source_type_id = 5
1837: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)

Line 2684: FROM mtl_material_transactions mmt

2680: mmt.organization_id org_id,
2681: mmt.subinventory_code subinv,
2682: mmt.transaction_action_id txn_action_id,
2683: mmt.transaction_source_type_id txn_src_type_id
2684: FROM mtl_material_transactions mmt
2685: WHERE mmt.transaction_date BETWEEN TRUNC(p_start_date)
2686: AND (TRUNC(p_end_date) + 0.99999)
2687: AND mmt.transaction_source_type_id = 5
2688: AND mmt.transaction_source_id = p_entity_id

Line 2702: FROM mtl_material_transactions mmt

2698: mmt.organization_id org_id,
2699: mmt.subinventory_code subinv,
2700: mmt.transaction_action_id txn_action_id,
2701: mmt.transaction_source_type_id txn_src_type_id
2702: FROM mtl_material_transactions mmt
2703: WHERE mmt.transaction_date BETWEEN TRUNC(p_start_date)
2704: AND (TRUNC(p_end_date) + 0.99999)
2705: AND mmt.transaction_source_type_id = 5
2706: AND mmt.transaction_source_id = p_entity_id

Line 2788: FROM mtl_material_transactions mmt

2784: IF (p_scrap = 1 AND p_entity_type <> 4) THEN
2785:
2786: SELECT SUM(mmt.primary_quantity)
2787: INTO l_net_completion
2788: FROM mtl_material_transactions mmt
2789: WHERE mmt.transaction_source_id = p_entity_id
2790: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)
2791: AND (TRUNC(p_end_date) + 0.99999)
2792: AND mmt.transaction_source_type_id = 5

Line 3328: FROM mtl_material_transactions mmt

3324: IF p_final_completion_flag = 1 THEN
3325:
3326: SELECT sum(primary_quantity)
3327: INTO l_assembly_return_cnt
3328: FROM mtl_material_transactions mmt
3329: WHERE mmt.transaction_source_id = p_entity_id
3330: AND mmt.transaction_action_id = 32
3331: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)
3332: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4532: FROM mtl_material_transactions mmt

4528:
4529: l_stmt_num := 48;
4530: SELECT sum(primary_quantity)
4531: INTO l_assembly_return_cnt
4532: FROM mtl_material_transactions mmt
4533: WHERE mmt.transaction_source_id = p_entity_id
4534: AND mmt.transaction_action_id = 32
4535: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)
4536: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 5080: FROM mtl_material_transactions mmt

5076: IF ( p_net_qty = 0 and p_final_completion_flag = 1 ) then
5077:
5078: SELECT sum(primary_quantity)
5079: INTO l_completed_assembly_qty
5080: FROM mtl_material_transactions mmt
5081: WHERE mmt.transaction_source_id = p_entity_id
5082: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)
5083: AND mmt.transaction_action_id = 31
5084: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 5203: UPDATE MTL_MATERIAL_TRANSACTIONS

5199: -- ================================================================
5200: -- FP 12.0-12.1.3 Bug 9280484 fix: Update periodic primary quantity
5201: -- with converted UOM transaction quantity
5202: -- ================================================================
5203: UPDATE MTL_MATERIAL_TRANSACTIONS
5204: SET PERIODIC_PRIMARY_QUANTITY = c_txn_rec.pri_qty * l_uom_conv_rate
5205: WHERE TRANSACTION_ID = c_txn_rec.txn_id;
5206:
5207: END LOOP; --scrap_txn_loop

Line 5320: UPDATE MTL_MATERIAL_TRANSACTIONS

5316: -- =================================================================
5317: -- FP 12.0-12.1.3 Bug 9280484 fix: Update periodic primary quantity
5318: -- with converted UOM transaction quantity
5319: -- =================================================================
5320: UPDATE MTL_MATERIAL_TRANSACTIONS
5321: SET PERIODIC_PRIMARY_QUANTITY = c_txn_rec.pri_qty * l_uom_conv_rate
5322: WHERE TRANSACTION_ID = c_txn_rec.txn_id;
5323:
5324: END LOOP; --assy_txn_loop

Line 5447: FROM mtl_material_transactions mmt,

5443: we.entity_type entity_type,
5444: mmt.repetitive_line_id line_id,
5445: mmt.operation_seq_num op_seq,
5446: SUM(mmt.primary_quantity) net_scrap
5447: FROM mtl_material_transactions mmt,
5448: cst_cost_group_assignments ccga,
5449: wip_entities we
5450: WHERE mmt.inventory_item_id = p_item_id
5451: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 5460: FROM mtl_material_transactions mmt1

5456: AND ccga.cost_group_id = p_cost_group_id
5457: AND we.wip_entity_id = mmt.transaction_source_id
5458: AND we.organization_id = mmt.organization_id
5459: AND NOT EXISTS (SELECT 1
5460: FROM mtl_material_transactions mmt1
5461: WHERE mmt1.inventory_item_id = we.primary_item_id
5462: AND mmt1.transaction_source_id = we.wip_entity_id
5463: AND mmt1.organization_id = we.organization_id
5464: AND mmt1.transaction_source_type_id = 5

Line 5493: FROM mtl_material_transactions mmt,

5489: mmt.organization_id org_id,
5490: we.entity_type entity_type,
5491: mmt.repetitive_line_id line_id,
5492: SUM(mmt.primary_quantity) net_completion
5493: FROM mtl_material_transactions mmt,
5494: cst_cost_group_assignments ccga,
5495: wip_entities we
5496: WHERE mmt.inventory_item_id = p_item_id
5497: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 5506: FROM mtl_material_transactions mmt1

5502: AND ccga.cost_group_id = p_cost_group_id
5503: AND we.wip_entity_id = mmt.transaction_source_id
5504: AND we.organization_id = mmt.organization_id
5505: AND NOT EXISTS (SELECT 1
5506: FROM mtl_material_transactions mmt1
5507: WHERE mmt1.inventory_item_id = we.primary_item_id
5508: AND mmt1.transaction_source_id = we.wip_entity_id
5509: AND mmt1.organization_id = we.organization_id
5510: AND mmt1.transaction_source_type_id = 5

Line 5704: FROM mtl_material_transactions mmt

5700: l_stmt_num := 35;
5701:
5702: SELECT count(*)
5703: INTO l_final_completion_count
5704: FROM mtl_material_transactions mmt
5705: WHERE mmt.transaction_source_id = c_ent_rec.entity_id
5706: AND nvl(mmt.repetitive_line_id,-99) = nvl( c_ent_rec.line_id,-99)
5707: /* Bug 12703830 */
5708: AND mmt.transaction_action_id = 31

Line 5948: FROM mtl_material_transactions mmt,

5944: mmt.primary_quantity pri_qty,
5945: mmt.inventory_item_id item_id,
5946: mmt.operation_seq_num op_seq,
5947: mmt.organization_id org_id
5948: FROM mtl_material_transactions mmt,
5949: wip_entities we,
5950: cst_cost_group_assignments ccga /* bug3930450 - Added ccga join to process txns for a particular cost group */
5951: WHERE mmt.transaction_date BETWEEN TRUNC(p_start_date)
5952: AND (TRUNC(p_end_date) + 0.99999)

Line 5977: FROM mtl_material_transactions mmt,

5973: we.entity_type entity_type,
5974: mmt.repetitive_line_id line_id,
5975: mmt.operation_seq_num op_seq,
5976: SUM(mmt.primary_quantity) net_scrap
5977: FROM mtl_material_transactions mmt,
5978: cst_cost_group_assignments ccga,
5979: wip_entities we
5980: WHERE mmt.inventory_item_id = p_item_id
5981: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 5990: FROM mtl_material_transactions mmt1

5986: AND ccga.cost_group_id = p_cost_group_id
5987: AND we.wip_entity_id = mmt.transaction_source_id
5988: AND we.organization_id = mmt.organization_id
5989: AND EXISTS (SELECT 1
5990: FROM mtl_material_transactions mmt1
5991: WHERE mmt1.inventory_item_id = we.primary_item_id
5992: AND mmt1.transaction_source_id = we.wip_entity_id
5993: AND mmt1.organization_id = we.organization_id
5994: AND mmt1.transaction_source_type_id = 5

Line 6022: FROM mtl_material_transactions mmt,

6018: mmt.organization_id org_id,
6019: we.entity_type entity_type,
6020: mmt.repetitive_line_id line_id,
6021: SUM(mmt.primary_quantity) net_completion
6022: FROM mtl_material_transactions mmt,
6023: cst_cost_group_assignments ccga,
6024: wip_entities we
6025: WHERE mmt.inventory_item_id = p_item_id
6026: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 6035: FROM mtl_material_transactions mmt1

6031: AND ccga.cost_group_id = p_cost_group_id
6032: AND we.wip_entity_id = mmt.transaction_source_id
6033: AND we.organization_id = mmt.organization_id
6034: AND EXISTS(SELECT 1
6035: FROM mtl_material_transactions mmt1
6036: WHERE mmt1.inventory_item_id = we.primary_item_id
6037: AND mmt1.transaction_source_id = we.wip_entity_id
6038: AND mmt1.organization_id = we.organization_id
6039: AND mmt1.transaction_source_type_id = 5

Line 6341: FROM mtl_material_transactions mmt

6337: l_co_txns_count := l_co_txns_count + 1;
6338:
6339: SELECT count(*)
6340: INTO l_final_completion_count
6341: FROM mtl_material_transactions mmt
6342: WHERE mmt.transaction_source_id = c_ent_rec.entity_id
6343: AND nvl(mmt.repetitive_line_id,-99) = nvl( c_ent_rec.line_id,-99)
6344: /* Bug 12703830 */
6345: AND mmt.transaction_action_id = 31