APPS.CSTPPWAS dependencies on WIP_ENTITIES

Line 1136: FROM wip_entities

1132: SELECT entity_type,
1133: organization_id
1134: INTO l_entity_type,
1135: l_org_id
1136: FROM wip_entities
1137: WHERE wip_entity_id = p_entity_id;
1138:
1139: IF (l_entity_type <> 2) THEN -- Exclude repetitive schedules.
1140:

Line 3966: FROM wip_entities we

3962: SELECT NVL(we.primary_item_id,-1),
3963: we.organization_id
3964: INTO l_item_id,
3965: l_org_id
3966: FROM wip_entities we
3967: WHERE we.wip_entity_id = p_entity_id;
3968:
3969: IF (l_item_id <> -1) THEN
3970: l_stmt_num := 65;

Line 4365: wip_entities we

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)
4368: AND (TRUNC(p_end_date) + 0.99999)
4369: AND mmt.transaction_source_type_id = 5

Line 4411: wip_entities we

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)
4414: AND (TRUNC(p_end_date) + 0.99999)
4415: AND mmt.transaction_source_type_id = 5

Line 4446: -- Populates all the wip entities for this assembly

4442:
4443: ------------------------------------------------------------------------------
4444: -- This Cursor will get all scrap quantity without scrap account
4445: -- in this period for a given assembly
4446: -- Populates all the wip entities for this assembly
4447: ------------------------------------------------------------------------------
4448: CURSOR scrap_no_account is
4449: SELECT wmt.transaction_id wip_txn_id,
4450: wmt.wip_entity_id wip_entity,

Line 4938: wip_entities we,

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

Line 4968: wip_entities we

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)
4971: AND (TRUNC(p_end_date) + 0.99999)
4972: AND mmt.transaction_source_type_id = 5

Line 5013: wip_entities we

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)
5016: AND (TRUNC(p_end_date) + 0.99999)
5017: AND mmt.transaction_source_type_id = 5