[Home] [Help]
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)
5452: AND (TRUNC(p_end_date) + 0.99999)
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)
5498: AND (TRUNC(p_end_date) + 0.99999)
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)
5953: AND ccga.cost_group_id = p_cost_group_id /* bug3930450 */
5954: AND ccga.organization_id = mmt.organization_id /* bug3930450 */
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)
5982: AND (TRUNC(p_end_date) + 0.99999)
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)
6027: AND (TRUNC(p_end_date) + 0.99999)