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 561: wip_operation_resources WOR,

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

Line 1038: UPDATE WIP_OPERATION_RESOURCES W1

1034:
1035:
1036: l_stmt_num := 150;
1037:
1038: UPDATE WIP_OPERATION_RESOURCES W1
1039: SET
1040: (RELIEVED_RES_SCRAP_UNITS,
1041: TEMP_RELIEVED_VALUE,
1042: RELIEVED_RES_scrap_VALUE) =

Line 1062: WIP_OPERATION_RESOURCES W2,

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

Line 1162: wip_operation_resources WOR,

1158: i_prog_appl_id, /* program_application_id, */
1159: i_prog_id, /* program_id, */
1160: sysdate /* program_update_date */
1161: FROM
1162: wip_operation_resources WOR,
1163: bom_resources BR
1164: WHERE
1165: WOR.wip_entity_id = i_wip_entity_id AND
1166: WOR.organization_id = i_org_id AND