eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPACWC dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 99: wip_req_operation_cost_details

95: nvl(relieved_variance_value,0) -
96: nvl(relieved_matl_scrap_value,0)
97: )
98: FROM
99: wip_req_operation_cost_details
100: WHERE
101: wip_entity_id = i_wip_entity_id
102: GROUP BY
103: cost_element_id;

Line 135: UPDATE wip_req_operation_cost_details

131:
132:
133: stmt_num := 10;
134:
135: UPDATE wip_req_operation_cost_details
136: SET temp_relieved_value = 0
137: WHERE
138: WIP_ENTITY_ID = i_wip_entity_id AND
139: ORGANIZATION_ID = i_org_id;

Line 388: FROM wip_req_operation_cost_details wrocd

384: w.inventory_item_id = wro_rec.inventory_item_id AND /*added for bug 4246122 */
385: w.operation_seq_num = wro_rec.operation_seq_num /*added for bug 4246122 */
386: AND exists (
387: SELECT 'x'
388: FROM wip_req_operation_cost_details wrocd
389: WHERE wrocd.wip_entity_id = w.wip_entity_id
390: AND wrocd.organization_id = w.organization_id
391: GROUP BY
392: wrocd.wip_entity_id,

Line 426: FROM wip_req_operation_cost_details wrocd

422: w.inventory_item_id = wro_rec.inventory_item_id AND /* added for bug 4246122 */
423: w.operation_seq_num = wro_rec.operation_seq_num /*added for bug 4246122 */
424: AND not exists (
425: SELECT 'x'
426: FROM wip_req_operation_cost_details wrocd
427: WHERE wrocd.wip_entity_id = w.wip_entity_id
428: AND wrocd.organization_id = w.organization_id
429: GROUP BY
430: wrocd.wip_entity_id,

Line 448: UPDATE wip_req_operation_cost_details w

444: EXIT WHEN c_cost_elements%NOTFOUND;
445:
446: IF l_job_value >= 0 THEN
447: stmt_num := 110;
448: UPDATE wip_req_operation_cost_details w
449: SET relieved_matl_completion_value =
450: nvl(applied_matl_value,0)-
451: nvl(relieved_variance_value,0)-
452: nvl(relieved_matl_scrap_value,0),

Line 462: UPDATE wip_req_operation_cost_details w

458: WHERE w.wip_entity_id = i_wip_entity_id AND
459: w.cost_element_id = l_cost_element;
460: ELSE
461: stmt_num := 115;
462: UPDATE wip_req_operation_cost_details w
463: SET relieved_variance_value =
464: nvl(applied_matl_value,0)-
465: nvl(relieved_matl_completion_value,0)-
466: nvl(relieved_matl_scrap_value,0),

Line 938: FROM wip_req_operation_cost_details wrocd

934: w.inventory_item_id = wro_rec.inventory_item_id AND
935: w.operation_seq_num = wro_rec.operation_seq_num
936: AND exists (
937: SELECT 'x'
938: FROM wip_req_operation_cost_details wrocd
939: WHERE wrocd.wip_entity_id = w.wip_entity_id
940: AND wrocd.organization_id = w.organization_id
941: GROUP BY
942: wrocd.wip_entity_id,

Line 961: UPDATE wip_req_operation_cost_details w

957: EXIT WHEN c_cost_elements%NOTFOUND;
958:
959: IF l_job_value >= 0 THEN
960: stmt_num := 180;
961: UPDATE wip_req_operation_cost_details w
962: SET relieved_matl_completion_value =
963: nvl(applied_matl_value,0)-
964: nvl(relieved_variance_value,0)-
965: nvl(relieved_matl_scrap_value,0),

Line 1266: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

1262: -- If some components have been issued, they should not be inserted
1263:
1264: stmt_num := 240;
1265:
1266: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
1267: (WIP_ENTITY_ID,
1268: OPERATION_SEQ_NUM,
1269: ORGANIZATION_ID,
1270: INVENTORY_ITEM_ID,

Line 1312: WIP_REQ_OPERATION_COST_DETAILS WROCD

1308: not EXISTS
1309: (SELECT
1310: 'X'
1311: FROM
1312: WIP_REQ_OPERATION_COST_DETAILS WROCD
1313: WHERE
1314: WROCD.WIP_ENTITY_ID = i_wip_entity_id AND
1315: WROCD.INVENTORY_ITEM_ID= WRO.INVENTORY_ITEM_ID AND
1316: WROCD.OPERATION_SEQ_NUM= WRO.OPERATION_SEQ_NUM AND

Line 1366: UPDATE WIP_REQ_OPERATION_COST_DETAILS w1

1362: END;
1363:
1364: /* END IF; -- commented as bug fix 2391936 */
1365:
1366: UPDATE WIP_REQ_OPERATION_COST_DETAILS w1
1367: SET (temp_relieved_value,
1368: relieved_matl_completion_value) =
1369: (SELECT
1370: decode(SIGN(nvl(wro.quantity_issued,0)-

Line 1681: wip_req_operation_cost_details w2,

1677: 3,cql.resource_cost,
1678: 4,cql.outside_processing_cost,
1679: 5,cql.overhead_cost),0)))
1680: FROM
1681: wip_req_operation_cost_details w2,
1682: wip_requirement_operations wro,
1683: cst_quantity_layers cql
1684: WHERE
1685: w2.wip_entity_id = w1.wip_entity_id AND

Line 2964: WIP_REQ_OPERATION_COST_DETAILS wrocd

2960: i_prog_appl_id,
2961: i_prog_id,
2962: SYSDATE
2963: FROM
2964: WIP_REQ_OPERATION_COST_DETAILS wrocd
2965: where
2966: WIP_ENTITY_ID = i_wip_entity_id AND
2967: ORGANIZATION_ID = i_org_id
2968: GROUP BY wrocd.cost_element_id

Line 3671: UPDATE WIP_REQ_OPERATION_COST_DETAILS

3667: ***************************************************/
3668:
3669: stmt_num := 10;
3670:
3671: UPDATE WIP_REQ_OPERATION_COST_DETAILS
3672: SET temp_relieved_value = 0
3673: where
3674: WIP_ENTITY_ID = i_wip_entity_id;
3675:

Line 4011: UPDATE wip_req_operation_cost_details w1

4007: then
4008:
4009: stmt_num := 105;
4010:
4011: UPDATE wip_req_operation_cost_details w1
4012: SET
4013: (temp_relieved_value,
4014: relieved_matl_completion_value) =
4015: (SELECT

Line 4038: wip_req_operation_cost_details w2,

4034: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
4035: prior_completion_quantity)),
4036: 0)
4037: FROM
4038: wip_req_operation_cost_details w2,
4039: wip_requirement_operations wro,
4040: cst_comp_snapshot cocd
4041: WHERE
4042: w1.wip_entity_id = w2.wip_entity_id AND

Line 4079: wip_req_operation_cost_details wrocd,

4075: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
4076: prior_completion_quantity)),
4077: 0)
4078: FROM
4079: wip_req_operation_cost_details wrocd,
4080: wip_requirement_operations w2,
4081: cst_comp_snapshot cocd
4082: WHERE
4083: w1.wip_entity_id = w2.wip_entity_id AND

Line 4122: UPDATE wip_req_operation_cost_details w1

4118: WHERE organization_id = i_org_id;
4119:
4120: stmt_num := 115;
4121:
4122: UPDATE wip_req_operation_cost_details w1
4123: SET
4124: (temp_relieved_value,
4125: relieved_matl_completion_value) =
4126: (SELECT

Line 4205: wip_req_operation_cost_details w2,

4201: -1*relieved_matl_completion_value,
4202: 0)),
4203: 0)))
4204: FROM
4205: wip_req_operation_cost_details w2,
4206: wip_requirement_operations wro
4207: WHERE
4208: w1.wip_entity_id = w2.wip_entity_id AND
4209: w1.organization_id = w2.organization_id AND

Line 4271: wip_req_operation_cost_details wrocd,

4267: -1*relieved_matl_completion_qty,
4268: 0)),
4269: 0)))
4270: FROM
4271: wip_req_operation_cost_details wrocd,
4272: wip_requirement_operations w2
4273: WHERE
4274: w.wip_entity_id = w2.wip_entity_id AND
4275: w.inventory_item_id = w2.inventory_item_id AND

Line 4490: WIP_REQ_OPERATION_COST_DETAILS wrocd

4486: i_prog_appl_id,
4487: i_prog_id,
4488: SYSDATE
4489: FROM
4490: WIP_REQ_OPERATION_COST_DETAILS wrocd
4491: where
4492: WIP_ENTITY_ID = i_wip_entity_id AND
4493: ORGANIZATION_ID = i_org_id
4494: GROUP BY wrocd.cost_element_id