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 913: cst_comp_snapshot cocd

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

Line 1185: cst_comp_snapshot CCS

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

Line 1498: -- by percentage using cst_comp_snapshot

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

Line 1784: cst_comp_snapshot cocd

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

Line 1847: cst_comp_snapshot cocd

1843: 0)
1844:
1845: FROM
1846: wip_operation_overheads w2,
1847: cst_comp_snapshot cocd
1848: WHERE
1849: w2.wip_entity_id = w1.wip_entity_id AND
1850: w2.organization_id = w1.organization_id AND
1851: w2.operation_seq_num = w1.operation_seq_num AND