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 CST_COST_GROUP_ASSIGNMENTS

Line 4364: cst_cost_group_assignments ccga,

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)
4368: AND (TRUNC(p_end_date) + 0.99999)

Line 4410: cst_cost_group_assignments ccga,

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)
4414: AND (TRUNC(p_end_date) + 0.99999)

Line 4457: FROM cst_cost_group_assignments ccga,

4453: wmt.fm_intraoperation_step_type from_op_step,
4454: wmt.to_operation_seq_num to_op_seq,
4455: wmt.to_intraoperation_step_type to_op_step,
4456: wmt.primary_quantity pri_qty
4457: FROM cst_cost_group_assignments ccga,
4458: wip_move_transactions wmt
4459: WHERE wmt.transaction_date BETWEEN TRUNC(p_start_date)
4460: AND (TRUNC(p_end_date) + 0.99999)
4461: AND wmt.organization_id = ccga.organization_id

Line 4939: cst_cost_group_assignments ccga /* bug3930450 - Added ccga join to process txns for a particular cost group */

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 */
4943: AND ccga.organization_id = mmt.organization_id /* bug3930450 */

Line 4967: cst_cost_group_assignments ccga,

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)
4971: AND (TRUNC(p_end_date) + 0.99999)

Line 5012: cst_cost_group_assignments ccga,

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)
5016: AND (TRUNC(p_end_date) + 0.99999)