APPS.CSTPACWC dependencies on CST_COMP_SNAPSHOT

Line 1775: cst_comp_snapshot cocd

1771: 1),
1772: 0)
1773: FROM
1774: wip_operation_resources w2,
1775: cst_comp_snapshot cocd
1776: WHERE
1777: w1.wip_entity_id = w2.wip_entity_id AND
1778: w1.operation_seq_num = w2.operation_seq_num AND
1779: w1.resource_seq_num = w2.resource_seq_num AND

Line 1863: cst_comp_snapshot cocd

1859: 1),
1860: 0)
1861: FROM
1862: wip_operation_overheads w2,
1863: cst_comp_snapshot cocd
1864: WHERE
1865: w1.wip_entity_id = w2.wip_entity_id AND
1866: w1.operation_seq_num = w2.operation_seq_num AND
1867: w1.resource_seq_num = w2.resource_seq_num AND

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

3820:
3821: /* Bug fix for 2138569
3822: For jobs that have no routing, but the assembly has a BOM.
3823: The table cst_comp_snap_temp does not get populated and thus
3824: there are no rows in cst_comp_snapshot table. Resulting which
3825: the calculations based on the CCS table returns zero value.
3826: And value of Assembly returned is incorrect.
3827:
3828: To fix this, have decided to check if the wip_operations table

Line 3874: cst_comp_snapshot cocd

3870: prior_completion_quantity)),
3871: 0)
3872: FROM
3873: wip_req_operation_cost_details w2,
3874: cst_comp_snapshot cocd
3875: WHERE
3876: w1.wip_entity_id = w2.wip_entity_id AND
3877: w1.organization_id = w2.organization_id AND
3878: w1.operation_seq_num = w2.operation_seq_num AND

Line 3910: cst_comp_snapshot cocd

3906: 0)
3907: FROM
3908: wip_req_operation_cost_details wrocd,
3909: wip_requirement_operations w2,
3910: cst_comp_snapshot cocd
3911: WHERE
3912: w1.wip_entity_id = w2.wip_entity_id AND
3913: w1.inventory_item_id = w2.inventory_item_id AND
3914: w1.operation_seq_num = w2.operation_seq_num AND

Line 4181: cst_comp_snapshot cocd

4177: prior_completion_quantity)),
4178: 0)
4179: FROM
4180: wip_operation_resources w2,
4181: cst_comp_snapshot cocd
4182: WHERE
4183: w2.wip_entity_id = w1.wip_entity_id AND
4184: w2.organization_id = w1.organization_id AND
4185: w2.operation_seq_num = w1.operation_seq_num AND

Line 4241: cst_comp_snapshot cocd

4237: 0)
4238:
4239: FROM
4240: wip_operation_overheads w2,
4241: cst_comp_snapshot cocd
4242: WHERE
4243: w2.wip_entity_id = w1.wip_entity_id AND
4244: w2.organization_id = w1.organization_id AND
4245: w2.operation_seq_num = w1.operation_seq_num AND