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 1041: WIP_OPERATION_RESOURCES WOR

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

Line 1346: FROM wip_operation_resources wor

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

Line 1746: UPDATE wip_operation_resources w1

1742: --------------------------------------------------------------
1743:
1744: l_stmt_num := 120;
1745:
1746: UPDATE wip_operation_resources w1
1747: SET
1748: (relieved_res_completion_units,
1749: temp_relieved_value,
1750: relieved_res_completion_value) =

Line 1785: wip_operation_resources w2,

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

Line 1967: WIP_OPERATION_RESOURCES WOR

1963: i_prog_id,
1964: SYSDATE
1965: FROM
1966: BOM_RESOURCES BR,
1967: WIP_OPERATION_RESOURCES WOR
1968: WHERE
1969: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
1970: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND
1971: WOR.WIP_ENTITY_ID = i_wip_entity_id AND