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.CSTPACWS dependencies on WIP_OPERATION_RESOURCES

Line 63: UPDATE WIP_OPERATION_RESOURCES

59: WIP_ENTITY_ID = i_wip_entity_id;
60:
61: stmt_num := 20;
62:
63: UPDATE WIP_OPERATION_RESOURCES
64: SET temp_relieved_value = 0
65: where
66: WIP_ENTITY_ID = i_wip_entity_id;
67:

Line 586: UPDATE wip_operation_resources w1

582: IF (l_system_option_id = 1) THEN
583:
584: stmt_num := 140;
585:
586: UPDATE wip_operation_resources w1
587: SET
588: (relieved_res_scrap_units,
589: temp_relieved_value,
590: relieved_res_scrap_value) =

Line 658: wip_operation_resources w2,

654: nvl(prior_scrap_quantity,0)),
655: 1),
656: 0)
657: FROM
658: wip_operation_resources w2,
659: cst_comp_snapshot cocd
660: WHERE
661: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
662: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND

Line 775: UPDATE WIP_OPERATION_RESOURCES w1

771: -- ******************************************************/
772:
773: stmt_num := 150;
774:
775: UPDATE WIP_OPERATION_RESOURCES w1
776: SET
777: (relieved_res_scrap_units,
778: temp_relieved_value,
779: relieved_res_scrap_value) =

Line 952: wip_operation_resources w2,

948: 2,usage_rate_or_amount/i_lot_size,
949: usage_rate_or_amount)*
950: crc.resource_rate))
951: FROM
952: wip_operation_resources w2,
953: cst_resource_costs crc
954: WHERE
955: w2.wip_entity_id = w1.wip_entity_id AND
956: w2.operation_seq_num = w1.operation_seq_num AND

Line 1454: WIP_OPERATION_RESOURCES WOR,

1450: SYSDATE,
1451: SYSDATE
1452: FROM
1453: WIP_OPERATIONS WO,
1454: WIP_OPERATION_RESOURCES WOR,
1455: CST_DEPARTMENT_OVERHEADS CDO,
1456: CST_RESOURCE_OVERHEADS CRO
1457: WHERE
1458: WO.WIP_ENTITY_ID = i_wip_entity_id AND

Line 1663: wip_operation_resources wor,

1659: FROM
1660: wip_operation_overheads w2,
1661: cst_department_overheads cdo,
1662: wip_operations wo,
1663: wip_operation_resources wor,
1664: cst_resource_overheads cro
1665: WHERE
1666: w2.wip_entity_id = w1.wip_entity_id AND
1667: w2.organization_id = w1.organization_id AND

Line 1698: wip_operation_resources wor2

1694: FROM
1695: cst_department_overheads cdo2,
1696: wip_operations wo2,
1697: cst_resource_overheads cro2,
1698: wip_operation_resources wor2
1699: WHERE
1700: w1.wip_entity_id = wo2.wip_entity_id AND
1701: w1.organization_id = wo2.organization_id AND
1702: w1.operation_seq_num = wo2.operation_seq_num AND

Line 1851: WIP_OPERATION_RESOURCES WOR

1847: 0),
1848: 0))
1849: FROM
1850: WIP_OPERATION_OVERHEADS w2,
1851: WIP_OPERATION_RESOURCES WOR
1852: WHERE
1853: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1854: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1855: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND

Line 1876: WIP_OPERATION_RESOURCES WOR2

1872: FROM
1873: CST_DEPARTMENT_OVERHEADS CDO2,
1874: WIP_OPERATIONS WO2,
1875: CST_RESOURCE_OVERHEADS CRO2,
1876: WIP_OPERATION_RESOURCES WOR2
1877: WHERE
1878: W1.WIP_ENTITY_ID = WO2.WIP_ENTITY_ID AND
1879: W1.ORGANIZATION_ID = WO2.ORGANIZATION_ID AND
1880: W1.OPERATION_SEQ_NUM = WO2.OPERATION_SEQ_NUM AND

Line 1931: wip_operation_resources wor,

1927: -1,
1928: -1,
1929: SYSDATE
1930: FROM
1931: wip_operation_resources wor,
1932: bom_resources br
1933: WHERE
1934: br.resource_id = wor.resource_id AND
1935: br.organization_id = wor.organization_id AND

Line 2086: UPDATE WIP_OPERATION_RESOURCES

2082: WIP_ENTITY_ID = i_wip_entity_id;
2083:
2084: stmt_num := 20;
2085:
2086: UPDATE WIP_OPERATION_RESOURCES
2087: SET temp_relieved_value = 0
2088: where
2089: WIP_ENTITY_ID = i_wip_entity_id;
2090:

Line 2297: UPDATE WIP_OPERATION_RESOURCES W1

2293: If (l_system_option_id = 1) THEN
2294:
2295: stmt_num := 150;
2296:
2297: UPDATE WIP_OPERATION_RESOURCES W1
2298: SET
2299: (RELIEVED_RES_SCRAP_UNITS,
2300: TEMP_RELIEVED_VALUE,
2301: RELIEVED_RES_scrap_VALUE) =

Line 2318: WIP_OPERATION_RESOURCES W2,

2314: decode(abs(i_txn_qty),
2315: PRIOR_SCRAP_QUANTITY,-1,
2316: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
2317: FROM
2318: WIP_OPERATION_RESOURCES W2,
2319: cst_comp_snapshot COCD
2320: WHERE
2321: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2322: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND

Line 2383: UPDATE WIP_OPERATION_RESOURCES W1

2379: ELSE
2380:
2381: stmt_num := 160;
2382:
2383: UPDATE WIP_OPERATION_RESOURCES W1
2384: SET
2385: (RELIEVED_RES_SCRAP_UNITS,
2386: TEMP_RELIEVED_VALUE,
2387: RELIEVED_RES_SCRAP_VALUE) =

Line 2438: WIP_OPERATION_RESOURCES w2

2434: -1*nvl(relieved_res_scrap_value,0),
2435: -1*SIGN(usage_rate_or_amount),
2436: 0)
2437: FROM
2438: WIP_OPERATION_RESOURCES w2
2439: where
2440: w2.WIP_ENTITY_ID = w1.WIP_ENTITY_ID AND
2441: w2.OPERATION_SEQ_NUM = w1.OPERATION_SEQ_NUM AND
2442: w2.RESOURCE_SEQ_NUM = w1.RESOURCE_SEQ_NUM AND

Line 2589: WIP_OPERATION_RESOURCES WOR

2585: -1*SIGN(wor.usage_rate_or_amount),
2586: 0)
2587: FROM
2588: WIP_OPERATION_OVERHEADS W2,
2589: WIP_OPERATION_RESOURCES WOR
2590: where
2591: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2592: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2593: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND

Line 2645: WIP_OPERATION_RESOURCES wor,

2641: -1,
2642: -1,
2643: SYSDATE
2644: FROM
2645: WIP_OPERATION_RESOURCES wor,
2646: BOM_RESOURCES br
2647: WHERE
2648: br.RESOURCE_ID = WOR.RESOURCE_ID AND
2649: br.ORGANIZATION_ID = WOR.ORGANIZATION_ID AND