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 96: FROM mtl_material_transactions mmt

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

Line 1420: FROM mtl_material_transactions mmt

1416: ------------------------------------------------
1417: l_stmt_num := 110;
1418: SELECT sum(primary_quantity)
1419: INTO l_assembly_return_cnt
1420: FROM mtl_material_transactions mmt
1421: WHERE mmt.transaction_source_id = p_entity_id
1422: AND mmt.transaction_action_id = 32
1423: AND mmt.transaction_source_type_id = 5
1424: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)

Line 2243: FROM mtl_material_transactions mmt

2239: mmt.organization_id org_id,
2240: mmt.subinventory_code subinv,
2241: mmt.transaction_action_id txn_action_id,
2242: mmt.transaction_source_type_id txn_src_type_id
2243: FROM mtl_material_transactions mmt
2244: WHERE mmt.transaction_date BETWEEN TRUNC(p_start_date)
2245: AND (TRUNC(p_end_date) + 0.99999)
2246: AND mmt.transaction_source_type_id = 5
2247: AND mmt.transaction_source_id = p_entity_id

Line 2261: FROM mtl_material_transactions mmt

2257: mmt.organization_id org_id,
2258: mmt.subinventory_code subinv,
2259: mmt.transaction_action_id txn_action_id,
2260: mmt.transaction_source_type_id txn_src_type_id
2261: FROM mtl_material_transactions mmt
2262: WHERE mmt.transaction_date BETWEEN TRUNC(p_start_date)
2263: AND (TRUNC(p_end_date) + 0.99999)
2264: AND mmt.transaction_source_type_id = 5
2265: AND mmt.transaction_source_id = p_entity_id

Line 2335: FROM mtl_material_transactions mmt

2331: IF (p_scrap = 1 AND p_entity_type <> 4) THEN
2332:
2333: SELECT SUM(mmt.primary_quantity)
2334: INTO l_net_completion
2335: FROM mtl_material_transactions mmt
2336: WHERE mmt.transaction_source_id = p_entity_id
2337: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)
2338: AND (TRUNC(p_end_date) + 0.99999)
2339: AND mmt.transaction_source_type_id = 5

Line 2755: FROM mtl_material_transactions mmt

2751: IF p_final_completion_flag = 1 THEN
2752:
2753: SELECT sum(primary_quantity)
2754: INTO l_assembly_return_cnt
2755: FROM mtl_material_transactions mmt
2756: WHERE mmt.transaction_source_id = p_entity_id
2757: AND mmt.transaction_action_id = 32
2758: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)
2759: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 3578: FROM mtl_material_transactions mmt

3574:
3575: l_stmt_num := 48;
3576: SELECT sum(primary_quantity)
3577: INTO l_assembly_return_cnt
3578: FROM mtl_material_transactions mmt
3579: WHERE mmt.transaction_source_id = p_entity_id
3580: AND mmt.transaction_action_id = 32
3581: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)
3582: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4012: FROM mtl_material_transactions mmt

4008: IF ( p_net_qty = 0 and p_final_completion_flag = 1 ) then
4009:
4010: SELECT sum(primary_quantity)
4011: INTO l_completed_assembly_qty
4012: FROM mtl_material_transactions mmt
4013: WHERE mmt.transaction_source_id = p_entity_id
4014: AND nvl(mmt.repetitive_line_id,-99) = nvl(p_line_id,-99)
4015: AND mmt.transaction_action_id = 31
4016: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4363: FROM mtl_material_transactions mmt,

4359: we.entity_type entity_type,
4360: mmt.repetitive_line_id line_id,
4361: mmt.operation_seq_num op_seq,
4362: SUM(mmt.primary_quantity) net_scrap
4363: FROM mtl_material_transactions mmt,
4364: cst_cost_group_assignments ccga,
4365: wip_entities we
4366: WHERE mmt.inventory_item_id = p_item_id
4367: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4376: FROM mtl_material_transactions mmt1

4372: AND ccga.cost_group_id = p_cost_group_id
4373: AND we.wip_entity_id = mmt.transaction_source_id
4374: AND we.organization_id = mmt.organization_id
4375: AND NOT EXISTS (SELECT 1
4376: FROM mtl_material_transactions mmt1
4377: WHERE mmt1.inventory_item_id = we.primary_item_id
4378: AND mmt1.transaction_source_id = we.wip_entity_id
4379: AND mmt1.organization_id = we.organization_id
4380: AND mmt1.transaction_source_type_id = 5

Line 4409: FROM mtl_material_transactions mmt,

4405: mmt.organization_id org_id,
4406: we.entity_type entity_type,
4407: mmt.repetitive_line_id line_id,
4408: SUM(mmt.primary_quantity) net_completion
4409: FROM mtl_material_transactions mmt,
4410: cst_cost_group_assignments ccga,
4411: wip_entities we
4412: WHERE mmt.inventory_item_id = p_item_id
4413: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4422: FROM mtl_material_transactions mmt1

4418: AND ccga.cost_group_id = p_cost_group_id
4419: AND we.wip_entity_id = mmt.transaction_source_id
4420: AND we.organization_id = mmt.organization_id
4421: AND NOT EXISTS (SELECT 1
4422: FROM mtl_material_transactions mmt1
4423: WHERE mmt1.inventory_item_id = we.primary_item_id
4424: AND mmt1.transaction_source_id = we.wip_entity_id
4425: AND mmt1.organization_id = we.organization_id
4426: AND mmt1.transaction_source_type_id = 5

Line 4711: FROM mtl_material_transactions mmt

4707: l_stmt_num := 75;
4708:
4709: SELECT count(*)
4710: INTO l_final_completion_count
4711: FROM mtl_material_transactions mmt
4712: WHERE mmt.transaction_source_id = c_ent_rec.entity_id
4713: AND nvl(mmt.repetitive_line_id,-99) = nvl( c_ent_rec.line_id,-99)
4714: AND mmt.final_completion_flag = 'Y'
4715: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4937: FROM mtl_material_transactions mmt,

4933: mmt.primary_quantity pri_qty,
4934: mmt.inventory_item_id item_id,
4935: mmt.operation_seq_num op_seq,
4936: mmt.organization_id org_id
4937: FROM mtl_material_transactions mmt,
4938: wip_entities we,
4939: cst_cost_group_assignments ccga /* bug3930450 - Added ccga join to process txns for a particular cost group */
4940: WHERE mmt.transaction_date BETWEEN TRUNC(p_start_date)
4941: AND (TRUNC(p_end_date) + 0.99999)

Line 4966: FROM mtl_material_transactions mmt,

4962: we.entity_type entity_type,
4963: mmt.repetitive_line_id line_id,
4964: mmt.operation_seq_num op_seq,
4965: SUM(mmt.primary_quantity) net_scrap
4966: FROM mtl_material_transactions mmt,
4967: cst_cost_group_assignments ccga,
4968: wip_entities we
4969: WHERE mmt.inventory_item_id = p_item_id
4970: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 4979: FROM mtl_material_transactions mmt1

4975: AND ccga.cost_group_id = p_cost_group_id
4976: AND we.wip_entity_id = mmt.transaction_source_id
4977: AND we.organization_id = mmt.organization_id
4978: AND EXISTS (SELECT 1
4979: FROM mtl_material_transactions mmt1
4980: WHERE mmt1.inventory_item_id = we.primary_item_id
4981: AND mmt1.transaction_source_id = we.wip_entity_id
4982: AND mmt1.organization_id = we.organization_id
4983: AND mmt1.transaction_source_type_id = 5

Line 5011: FROM mtl_material_transactions mmt,

5007: mmt.organization_id org_id,
5008: we.entity_type entity_type,
5009: mmt.repetitive_line_id line_id,
5010: SUM(mmt.primary_quantity) net_completion
5011: FROM mtl_material_transactions mmt,
5012: cst_cost_group_assignments ccga,
5013: wip_entities we
5014: WHERE mmt.inventory_item_id = p_item_id
5015: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)

Line 5024: FROM mtl_material_transactions mmt1

5020: AND ccga.cost_group_id = p_cost_group_id
5021: AND we.wip_entity_id = mmt.transaction_source_id
5022: AND we.organization_id = mmt.organization_id
5023: AND EXISTS(SELECT 1
5024: FROM mtl_material_transactions mmt1
5025: WHERE mmt1.inventory_item_id = we.primary_item_id
5026: AND mmt1.transaction_source_id = we.wip_entity_id
5027: AND mmt1.organization_id = we.organization_id
5028: AND mmt1.transaction_source_type_id = 5

Line 5316: FROM mtl_material_transactions mmt

5312: l_co_txns_count := l_co_txns_count + 1;
5313:
5314: SELECT count(*)
5315: INTO l_final_completion_count
5316: FROM mtl_material_transactions mmt
5317: WHERE mmt.transaction_source_id = c_ent_rec.entity_id
5318: AND nvl(mmt.repetitive_line_id,-99) = nvl( c_ent_rec.line_id,-99)
5319: AND mmt.final_completion_flag = 'Y'
5320: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)