APPS.CSTPLCAS dependencies on WIP_OPERATION_RESOURCES

Line 343: UPDATE wip_operation_resources w1

339:
340:
341: l_stmt_num := 160;
342:
343: UPDATE wip_operation_resources w1
344: SET
345: (relieved_res_scrap_units,
346: temp_relieved_value,
347: relieved_res_scrap_value) =

Line 415: wip_operation_resources w2,

411: nvl(prior_scrap_quantity,0)),
412: 1),
413: 0)
414: FROM
415: wip_operation_resources w2,
416: cst_comp_snapshot cocd
417: WHERE
418: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
419: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND

Line 559: wip_operation_resources WOR,

555: i_prog_appl_id, /* program_application_id, */
556: i_prog_id, /* program_id, */
557: sysdate /* program_update_date */
558: FROM
559: wip_operation_resources WOR,
560: bom_resources BR
561: WHERE
562: WOR.wip_entity_id = i_wip_entity_id AND
563: WOR.organization_id = i_org_id AND

Line 1035: UPDATE WIP_OPERATION_RESOURCES W1

1031:
1032:
1033: l_stmt_num := 150;
1034:
1035: UPDATE WIP_OPERATION_RESOURCES W1
1036: SET
1037: (RELIEVED_RES_SCRAP_UNITS,
1038: TEMP_RELIEVED_VALUE,
1039: RELIEVED_RES_scrap_VALUE) =

Line 1059: WIP_OPERATION_RESOURCES W2,

1055: PRIOR_SCRAP_QUANTITY,-1,
1056: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,
1057: PRIOR_SCRAP_QUANTITY))
1058: FROM
1059: WIP_OPERATION_RESOURCES W2,
1060: cst_comp_snapshot COCD
1061: WHERE
1062: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1063: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND

Line 1157: wip_operation_resources WOR,

1153: i_prog_appl_id, /* program_application_id, */
1154: i_prog_id, /* program_id, */
1155: sysdate /* program_update_date */
1156: FROM
1157: wip_operation_resources WOR,
1158: bom_resources BR
1159: WHERE
1160: WOR.wip_entity_id = i_wip_entity_id AND
1161: WOR.organization_id = i_org_id AND