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 1631: wip_req_operation_cost_details w2,

1627: 3,cql.resource_cost,
1628: 4,cql.outside_processing_cost,
1629: 5,cql.overhead_cost),0)))
1630: FROM
1631: wip_req_operation_cost_details w2,
1632: wip_requirement_operations wro,
1633: cst_quantity_layers cql
1634: WHERE
1635: w2.wip_entity_id = w1.wip_entity_id AND

Line 2828: WIP_REQ_OPERATION_COST_DETAILS wrocd

2824: i_prog_appl_id,
2825: i_prog_id,
2826: SYSDATE
2827: FROM
2828: WIP_REQ_OPERATION_COST_DETAILS wrocd
2829: where
2830: WIP_ENTITY_ID = i_wip_entity_id AND
2831: ORGANIZATION_ID = i_org_id
2832: GROUP BY wrocd.cost_element_id

Line 3506: UPDATE WIP_REQ_OPERATION_COST_DETAILS

3502: ***************************************************/
3503:
3504: stmt_num := 10;
3505:
3506: UPDATE WIP_REQ_OPERATION_COST_DETAILS
3507: SET temp_relieved_value = 0
3508: where
3509: WIP_ENTITY_ID = i_wip_entity_id;
3510:

Line 3846: UPDATE wip_req_operation_cost_details w1

3842: then
3843:
3844: stmt_num := 105;
3845:
3846: UPDATE wip_req_operation_cost_details w1
3847: SET
3848: (temp_relieved_value,
3849: relieved_matl_completion_value) =
3850: (SELECT

Line 3873: wip_req_operation_cost_details w2,

3869: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
3870: prior_completion_quantity)),
3871: 0)
3872: FROM
3873: wip_req_operation_cost_details w2,
3874: cst_comp_snapshot cocd
3875: WHERE
3876: w1.wip_entity_id = w2.wip_entity_id AND
3877: w1.organization_id = w2.organization_id AND

Line 3908: wip_req_operation_cost_details wrocd,

3904: i_txn_qty/decode(prior_completion_quantity,null,1,0,1,
3905: prior_completion_quantity)),
3906: 0)
3907: FROM
3908: wip_req_operation_cost_details wrocd,
3909: wip_requirement_operations w2,
3910: cst_comp_snapshot cocd
3911: WHERE
3912: w1.wip_entity_id = w2.wip_entity_id AND

Line 3950: UPDATE wip_req_operation_cost_details w1

3946: WHERE organization_id = i_org_id;
3947:
3948: stmt_num := 115;
3949:
3950: UPDATE wip_req_operation_cost_details w1
3951: SET
3952: (temp_relieved_value,
3953: relieved_matl_completion_value) =
3954: (SELECT

Line 4033: wip_req_operation_cost_details w2,

4029: -1*relieved_matl_completion_value,
4030: 0)),
4031: 0)))
4032: FROM
4033: wip_req_operation_cost_details w2,
4034: wip_requirement_operations wro
4035: WHERE
4036: w1.wip_entity_id = w2.wip_entity_id AND
4037: w1.organization_id = w2.organization_id AND

Line 4099: wip_req_operation_cost_details wrocd,

4095: -1*relieved_matl_completion_qty,
4096: 0)),
4097: 0)))
4098: FROM
4099: wip_req_operation_cost_details wrocd,
4100: wip_requirement_operations w2
4101: WHERE
4102: w.wip_entity_id = w2.wip_entity_id AND
4103: w.inventory_item_id = w2.inventory_item_id AND

Line 4316: WIP_REQ_OPERATION_COST_DETAILS wrocd

4312: i_prog_appl_id,
4313: i_prog_id,
4314: SYSDATE
4315: FROM
4316: WIP_REQ_OPERATION_COST_DETAILS wrocd
4317: where
4318: WIP_ENTITY_ID = i_wip_entity_id AND
4319: ORGANIZATION_ID = i_org_id
4320: GROUP BY wrocd.cost_element_id