APPS.CSTPLCAS dependencies on WIP_OPERATION_OVERHEADS

Line 435: UPDATE wip_operation_overheads w1

431:
432:
433: l_stmt_num := 170;
434:
435: UPDATE wip_operation_overheads w1
436: SET
437: (relieved_ovhd_scrap_units,
438: temp_relieved_value,
439: relieved_ovhd_scrap_value) =

Line 504: wip_operation_overheads W2,

500: nvl(prior_scrap_quantity,0)),
501: 1),
502: 0)
503: FROM
504: wip_operation_overheads W2,
505: cst_comp_snapshot COCD
506: WHERE
507: w1.wip_entity_id = w2.wip_entity_id AND
508: w1.operation_seq_num = w2.operation_seq_num AND

Line 610: wip_operation_overheads WOO

606: i_prog_appl_id, /* program_application_id, */
607: i_prog_id, /* program_id, */
608: sysdate /* program_update_date */
609: FROM
610: wip_operation_overheads WOO
611: WHERE
612: WOO.wip_entity_id = i_wip_entity_id AND
613: WOO.organization_id = i_org_id
614: HAVING

Line 1083: UPDATE wip_operation_overheads W1

1079:
1080:
1081: l_stmt_num := 160;
1082:
1083: UPDATE wip_operation_overheads W1
1084: SET
1085: (RELIEVED_ovhd_SCRAP_UNITS,
1086: TEMP_RELIEVED_VALUE,
1087: RELIEVED_ovhd_scrap_value) =

Line 1104: wip_operation_overheads W2,

1100: decode(abs(i_txn_qty),
1101: PRIOR_SCRAP_QUANTITY,-1,
1102: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
1103: FROM
1104: wip_operation_overheads W2,
1105: cst_comp_snapshot COCD
1106: WHERE
1107: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1108: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND

Line 1211: wip_operation_overheads WOO

1207: i_prog_appl_id, /* program_application_id, */
1208: i_prog_id, /* program_id, */
1209: sysdate /* program_update_date */
1210: FROM
1211: wip_operation_overheads WOO
1212: WHERE
1213: WOO.wip_entity_id = i_wip_entity_id AND
1214: WOO.organization_id = i_org_id
1215: HAVING