APPS.CSTPPWAS dependencies on WIP_ENTITIES

Line 1537: FROM wip_entities

1533: SELECT entity_type,
1534: organization_id
1535: INTO l_entity_type,
1536: l_org_id
1537: FROM wip_entities
1538: WHERE wip_entity_id = p_entity_id;
1539:
1540: IF (l_entity_type <> 2) THEN -- Exclude repetitive schedules.
1541:

Line 5034: FROM wip_entities we

5030: SELECT NVL(we.primary_item_id,-1),
5031: we.organization_id
5032: INTO l_item_id,
5033: l_org_id
5034: FROM wip_entities we
5035: WHERE we.wip_entity_id = p_entity_id;
5036:
5037: IF (l_item_id <> -1) THEN
5038: l_stmt_num := 65;

Line 5449: wip_entities we

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)
5453: AND mmt.transaction_source_type_id = 5

Line 5495: wip_entities we

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)
5499: AND mmt.transaction_source_type_id = 5

Line 5949: wip_entities we,

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)
5953: AND ccga.cost_group_id = p_cost_group_id /* bug3930450 */

Line 5979: wip_entities we

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)
5983: AND mmt.transaction_source_type_id = 5

Line 6024: wip_entities we

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)
6028: AND mmt.transaction_source_type_id = 5