APPS.CSTPLCAS dependencies on WIP_OPERATION_OVERHEADS

Line 434: UPDATE wip_operation_overheads w1

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

Line 503: wip_operation_overheads W2,

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

Line 608: wip_operation_overheads WOO

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

Line 1079: UPDATE wip_operation_overheads W1

1075:
1076:
1077: l_stmt_num := 160;
1078:
1079: UPDATE wip_operation_overheads W1
1080: SET
1081: (RELIEVED_ovhd_SCRAP_UNITS,
1082: TEMP_RELIEVED_VALUE,
1083: RELIEVED_ovhd_scrap_value) =

Line 1100: wip_operation_overheads W2,

1096: decode(abs(i_txn_qty),
1097: PRIOR_SCRAP_QUANTITY,-1,
1098: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
1099: FROM
1100: wip_operation_overheads W2,
1101: cst_comp_snapshot COCD
1102: WHERE
1103: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1104: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND

Line 1206: wip_operation_overheads WOO

1202: i_prog_appl_id, /* program_application_id, */
1203: i_prog_id, /* program_id, */
1204: sysdate /* program_update_date */
1205: FROM
1206: wip_operation_overheads WOO
1207: WHERE
1208: WOO.wip_entity_id = i_wip_entity_id AND
1209: WOO.organization_id = i_org_id
1210: HAVING