APPS.CSTPLCAC dependencies on WIP_OPERATION_RESOURCES

Line 238: FROM wip_operation_resources wor

234: WHERE wro.wip_entity_id = i_wip_entity_id
235: AND wro.quantity_per_assembly <>0
236: UNION ALL
237: SELECT NULL
238: FROM wip_operation_resources wor
239: WHERE wor.wip_entity_id = i_wip_entity_id
240: AND wor.usage_rate_or_amount <>0
241: );
242:

Line 752: UPDATE wip_operation_resources w1

748: -- both resources and overheads.
749:
750: l_stmt_num := 190;
751:
752: UPDATE wip_operation_resources w1
753: SET
754: (relieved_res_completion_units,
755: temp_relieved_value,
756: relieved_res_completion_value) =

Line 824: wip_operation_resources w2,

820: nvl(prior_scrap_quantity,0)),
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

Line 1039: WIP_OPERATION_RESOURCES WOR

1035: i_prog_id,
1036: SYSDATE
1037: FROM
1038: BOM_RESOURCES BR,
1039: WIP_OPERATION_RESOURCES WOR
1040: WHERE
1041: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
1042: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
1043: WOR.WIP_ENTITY_ID = i_wip_entity_id AND

Line 1343: FROM wip_operation_resources wor

1339: WHERE wro.wip_entity_id = i_wip_entity_id
1340: AND wro.quantity_per_assembly <>0
1341: UNION ALL
1342: SELECT NULL
1343: FROM wip_operation_resources wor
1344: WHERE wor.wip_entity_id = i_wip_entity_id
1345: AND wor.usage_rate_or_amount <>0
1346: );
1347:

Line 1743: UPDATE wip_operation_resources w1

1739: --------------------------------------------------------------
1740:
1741: l_stmt_num := 120;
1742:
1743: UPDATE wip_operation_resources w1
1744: SET
1745: (relieved_res_completion_units,
1746: temp_relieved_value,
1747: relieved_res_completion_value) =

Line 1782: wip_operation_resources w2,

1778: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
1779: prior_completion_quantity)),
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

Line 1962: WIP_OPERATION_RESOURCES WOR

1958: i_prog_id,
1959: SYSDATE
1960: FROM
1961: BOM_RESOURCES BR,
1962: WIP_OPERATION_RESOURCES WOR
1963: WHERE
1964: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
1965: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
1966: WOR.WIP_ENTITY_ID = i_wip_entity_id AND