APPS.CSTPLCAC dependencies on CST_COMP_SNAPSHOT

Line 825: cst_comp_snapshot cocd

821: 1),
822: 0)
823: FROM
824: wip_operation_resources w2,
825: cst_comp_snapshot cocd
826: WHERE
827: w1.wip_entity_id = w2.wip_entity_id AND
828: w1.operation_seq_num = w2.operation_seq_num AND
829: w1.resource_seq_num = w2.resource_seq_num AND

Line 914: cst_comp_snapshot cocd

910: 1),
911: 0)
912: FROM
913: wip_operation_overheads w2,
914: cst_comp_snapshot cocd
915: WHERE
916: w1.wip_entity_id = w2.wip_entity_id AND
917: w1.operation_seq_num = w2.operation_seq_num AND
918: w1.resource_seq_num = w2.resource_seq_num AND

Line 1187: cst_comp_snapshot CCS

1183: WRO.relieved_matl_completion_qty,
1184: decode( nvl( CCS.prior_completion_quantity, 0 ), 0, 1,
1185: i_txn_qty / CCS.prior_completion_quantity ) component_ratio
1186: from wip_requirement_operations WRO,
1187: cst_comp_snapshot CCS
1188: where WRO.wip_entity_id = i_wip_entity_id and
1189: WRO.wip_supply_type not in (4,5,6) and
1190: WRO.quantity_per_assembly <> 0 and
1191: CCS.transaction_id = i_txn_id and

Line 1501: -- by percentage using cst_comp_snapshot

1497: wro_rec.quantity_per_assembly;
1498:
1499:
1500: -- reduce the relieved_matl_completion_qty
1501: -- by percentage using cst_comp_snapshot
1502: l_txn_qty_remaining := nvl(wro_rec.relieved_matl_completion_qty, 0) *
1503: nvl(wro_rec.component_ratio, 0);
1504:
1505: LOOP

Line 1787: cst_comp_snapshot cocd

1783: 0)
1784: FROM
1785: wip_operation_resources w2,
1786: bom_resources BR,
1787: cst_comp_snapshot cocd
1788: WHERE
1789: w2.wip_entity_id = w1.wip_entity_id AND
1790: w2.organization_id = w1.organization_id AND
1791: w2.operation_seq_num = w1.operation_seq_num AND

Line 1851: cst_comp_snapshot cocd

1847: 0)
1848:
1849: FROM
1850: wip_operation_overheads w2,
1851: cst_comp_snapshot cocd
1852: WHERE
1853: w2.wip_entity_id = w1.wip_entity_id AND
1854: w2.organization_id = w1.organization_id AND
1855: w2.operation_seq_num = w1.operation_seq_num AND