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.

[Home] [Help]

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 644: UPDATE wip_operation_resources w1

640: IF (l_system_option_id = 1) THEN
641:
642: stmt_num := 140;
643:
644: UPDATE wip_operation_resources w1
645: SET
646: (relieved_res_scrap_units,
647: temp_relieved_value,
648: relieved_res_scrap_value) =

Line 716: wip_operation_resources w2,

712: nvl(prior_scrap_quantity,0)),
713: 1),
714: 0)
715: FROM
716: wip_operation_resources w2,
717: cst_comp_snapshot cocd
718: WHERE
719: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
720: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND

Line 835: UPDATE WIP_OPERATION_RESOURCES w1

831: -- ******************************************************/
832:
833: stmt_num := 150;
834:
835: UPDATE WIP_OPERATION_RESOURCES w1
836: SET
837: (relieved_res_scrap_units,
838: temp_relieved_value,
839: relieved_res_scrap_value) =

Line 1034: wip_operation_resources w2,

1030: 2,usage_rate_or_amount/i_lot_size,
1031: usage_rate_or_amount)*
1032: crc.resource_rate))
1033: FROM
1034: wip_operation_resources w2,
1035: cst_resource_costs crc
1036: WHERE
1037: w2.wip_entity_id = w1.wip_entity_id AND
1038: w2.operation_seq_num = w1.operation_seq_num AND

Line 1576: WIP_OPERATION_RESOURCES WOR,

1572: SYSDATE,
1573: SYSDATE
1574: FROM
1575: WIP_OPERATIONS WO,
1576: WIP_OPERATION_RESOURCES WOR,
1577: CST_DEPARTMENT_OVERHEADS CDO,
1578: CST_RESOURCE_OVERHEADS CRO
1579: WHERE
1580: WO.WIP_ENTITY_ID = i_wip_entity_id AND

Line 1815: wip_operation_resources wor,

1811: FROM
1812: wip_operation_overheads w2,
1813: cst_department_overheads cdo,
1814: wip_operations wo,
1815: wip_operation_resources wor,
1816: cst_resource_overheads cro
1817: WHERE
1818: w2.wip_entity_id = w1.wip_entity_id AND
1819: w2.organization_id = w1.organization_id AND

Line 1852: wip_operation_resources wor2

1848: FROM
1849: cst_department_overheads cdo2,
1850: wip_operations wo2,
1851: cst_resource_overheads cro2,
1852: wip_operation_resources wor2
1853: WHERE
1854: w1.wip_entity_id = wo2.wip_entity_id AND
1855: w1.organization_id = wo2.organization_id AND
1856: w1.operation_seq_num = wo2.operation_seq_num AND

Line 2005: WIP_OPERATION_RESOURCES WOR

2001: 0),
2002: 0))
2003: FROM
2004: WIP_OPERATION_OVERHEADS w2,
2005: WIP_OPERATION_RESOURCES WOR
2006: WHERE
2007: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2008: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2009: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND

Line 2030: WIP_OPERATION_RESOURCES WOR2

2026: FROM
2027: CST_DEPARTMENT_OVERHEADS CDO2,
2028: WIP_OPERATIONS WO2,
2029: CST_RESOURCE_OVERHEADS CRO2,
2030: WIP_OPERATION_RESOURCES WOR2
2031: WHERE
2032: W1.WIP_ENTITY_ID = WO2.WIP_ENTITY_ID AND
2033: W1.ORGANIZATION_ID = WO2.ORGANIZATION_ID AND
2034: W1.OPERATION_SEQ_NUM = WO2.OPERATION_SEQ_NUM AND

Line 2087: wip_operation_resources wor,

2083: -1,
2084: -1,
2085: SYSDATE
2086: FROM
2087: wip_operation_resources wor,
2088: bom_resources br
2089: WHERE
2090: br.resource_id = wor.resource_id AND
2091: br.organization_id = wor.organization_id AND

Line 2242: UPDATE WIP_OPERATION_RESOURCES

2238: WIP_ENTITY_ID = i_wip_entity_id;
2239:
2240: stmt_num := 20;
2241:
2242: UPDATE WIP_OPERATION_RESOURCES
2243: SET temp_relieved_value = 0
2244: where
2245: WIP_ENTITY_ID = i_wip_entity_id;
2246:

Line 2453: UPDATE WIP_OPERATION_RESOURCES W1

2449: If (l_system_option_id = 1) THEN
2450:
2451: stmt_num := 150;
2452:
2453: UPDATE WIP_OPERATION_RESOURCES W1
2454: SET
2455: (RELIEVED_RES_SCRAP_UNITS,
2456: TEMP_RELIEVED_VALUE,
2457: RELIEVED_RES_scrap_VALUE) =

Line 2474: WIP_OPERATION_RESOURCES W2,

2470: decode(abs(i_txn_qty),
2471: PRIOR_SCRAP_QUANTITY,-1,
2472: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
2473: FROM
2474: WIP_OPERATION_RESOURCES W2,
2475: cst_comp_snapshot COCD
2476: WHERE
2477: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2478: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND

Line 2541: UPDATE WIP_OPERATION_RESOURCES W1

2537: ELSE
2538:
2539: stmt_num := 160;
2540:
2541: UPDATE WIP_OPERATION_RESOURCES W1
2542: SET
2543: (RELIEVED_RES_SCRAP_UNITS,
2544: TEMP_RELIEVED_VALUE,
2545: RELIEVED_RES_SCRAP_VALUE) =

Line 2596: WIP_OPERATION_RESOURCES w2

2592: -1*nvl(relieved_res_scrap_value,0),
2593: -1*SIGN(usage_rate_or_amount),
2594: 0)
2595: FROM
2596: WIP_OPERATION_RESOURCES w2
2597: where
2598: w2.WIP_ENTITY_ID = w1.WIP_ENTITY_ID AND
2599: w2.OPERATION_SEQ_NUM = w1.OPERATION_SEQ_NUM AND
2600: w2.RESOURCE_SEQ_NUM = w1.RESOURCE_SEQ_NUM AND

Line 2747: WIP_OPERATION_RESOURCES WOR

2743: -1*SIGN(wor.usage_rate_or_amount),
2744: 0)
2745: FROM
2746: WIP_OPERATION_OVERHEADS W2,
2747: WIP_OPERATION_RESOURCES WOR
2748: where
2749: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
2750: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
2751: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND

Line 2803: WIP_OPERATION_RESOURCES wor,

2799: -1,
2800: -1,
2801: SYSDATE
2802: FROM
2803: WIP_OPERATION_RESOURCES wor,
2804: BOM_RESOURCES br
2805: WHERE
2806: br.RESOURCE_ID = WOR.RESOURCE_ID AND
2807: br.ORGANIZATION_ID = WOR.ORGANIZATION_ID AND