APPS.CSTPACWC dependencies on CST_COMP_SNAPSHOT

Line 1825: cst_comp_snapshot cocd

1821: 1),
1822: 0)
1823: FROM
1824: wip_operation_resources w2,
1825: cst_comp_snapshot cocd
1826: WHERE
1827: w1.wip_entity_id = w2.wip_entity_id AND
1828: w1.operation_seq_num = w2.operation_seq_num AND
1829: w1.resource_seq_num = w2.resource_seq_num AND

Line 1914: cst_comp_snapshot cocd

1910: 1),
1911: 0)
1912: FROM
1913: wip_operation_overheads w2,
1914: cst_comp_snapshot cocd
1915: WHERE
1916: w1.wip_entity_id = w2.wip_entity_id AND
1917: w1.operation_seq_num = w2.operation_seq_num AND
1918: w1.resource_seq_num = w2.resource_seq_num AND

Line 3989: there are no rows in cst_comp_snapshot table. Resulting which

3985:
3986: /* Bug fix for 2138569
3987: For jobs that have no routing, but the assembly has a BOM.
3988: The table cst_comp_snap_temp does not get populated and thus
3989: there are no rows in cst_comp_snapshot table. Resulting which
3990: the calculations based on the CCS table returns zero value.
3991: And value of Assembly returned is incorrect.
3992:
3993: To fix this, have decided to check if the wip_operations table

Line 4040: cst_comp_snapshot cocd

4036: 0)
4037: FROM
4038: wip_req_operation_cost_details w2,
4039: wip_requirement_operations wro,
4040: cst_comp_snapshot cocd
4041: WHERE
4042: w1.wip_entity_id = w2.wip_entity_id AND
4043: w1.organization_id = w2.organization_id AND
4044: w1.operation_seq_num = w2.operation_seq_num AND

Line 4081: cst_comp_snapshot cocd

4077: 0)
4078: FROM
4079: wip_req_operation_cost_details wrocd,
4080: wip_requirement_operations w2,
4081: cst_comp_snapshot cocd
4082: WHERE
4083: w1.wip_entity_id = w2.wip_entity_id AND
4084: w1.inventory_item_id = w2.inventory_item_id AND
4085: w1.operation_seq_num = w2.operation_seq_num AND

Line 4353: cst_comp_snapshot cocd

4349: prior_completion_quantity)),
4350: 0)
4351: FROM
4352: wip_operation_resources w2,
4353: cst_comp_snapshot cocd
4354: WHERE
4355: w2.wip_entity_id = w1.wip_entity_id AND
4356: w2.organization_id = w1.organization_id AND
4357: w2.operation_seq_num = w1.operation_seq_num AND

Line 4414: cst_comp_snapshot cocd

4410: 0)
4411:
4412: FROM
4413: wip_operation_overheads w2,
4414: cst_comp_snapshot cocd
4415: WHERE
4416: w2.wip_entity_id = w1.wip_entity_id AND
4417: w2.organization_id = w1.organization_id AND
4418: w2.operation_seq_num = w1.operation_seq_num AND