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.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_OPERATIONS

Line 312: from wip_operations

308: END IF;
309:
310: select first_unit_start_date,last_unit_completion_date
311: into l_first_unit_start_date,l_last_unit_completion_date
312: from wip_operations
313: where wip_entity_id = p_wip_entity_id
314: AND organization_id = p_organization_id
315: AND operation_seq_num = cur_row.operation_seq_num;
316:

Line 320: UPDATE wip_operations

316:
317: IF (cur_row.start_date is not null
318: AND cur_row.start_date < l_first_unit_start_date)
319: THEN
320: UPDATE wip_operations
321: set first_unit_start_date = cur_row.start_date,
322: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
323: where wip_entity_id = p_wip_entity_id
324: AND organization_id = p_organization_id

Line 330: UPDATE wip_operations

326: END IF;
327: IF (cur_row.completion_date is not null
328: AND cur_row.completion_date > l_last_unit_completion_date)
329: THEN
330: UPDATE wip_operations
331: set last_unit_completion_date = cur_row.completion_date,
332: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
333: where wip_entity_id = p_wip_entity_id
334: AND organization_id = p_organization_id

Line 389: wip_operations wo

385: is
386: select wo.first_unit_start_date,
387: rowidtochar(wor.rowid)
388: from wip_operation_resources wor,
389: wip_operations wo
390: where wo.wip_entity_id = wor.wip_entity_id
391: and wo.organization_id = wor.organization_id
392: and wo.operation_seq_num = wor.operation_seq_num
393: and wor.wip_entity_id = p_wip_entity_id

Line 616: from wip_operations

612: END IF;
613:
614: select first_unit_start_date,last_unit_completion_date
615: into l_first_unit_start_date,l_last_unit_completion_date
616: from wip_operations
617: where wip_entity_id = p_wip_entity_id
618: AND organization_id = p_organization_id
619: AND operation_seq_num = cur_row.operation_seq_num;
620:

Line 624: UPDATE wip_operations

620:
621: IF (cur_row.start_date is not null
622: AND cur_row.start_date < l_first_unit_start_date)
623: THEN
624: UPDATE wip_operations
625: set first_unit_start_date = cur_row.start_date,
626: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
627: where wip_entity_id = p_wip_entity_id
628: AND organization_id = p_organization_id

Line 634: UPDATE wip_operations

630: END IF;
631: IF (cur_row.completion_date is not null
632: AND cur_row.completion_date > l_last_unit_completion_date)
633: THEN
634: UPDATE wip_operations
635: set last_unit_completion_date = cur_row.completion_date,
636: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
637: where wip_entity_id = p_wip_entity_id
638: AND organization_id = p_organization_id

Line 1704: FROM wip_operations

1700:
1701: CURSOR operations(p_wip_entity_id number,
1702: p_organization_id number) IS
1703: SELECT operation_seq_num
1704: FROM wip_operations
1705: WHERE wip_entity_id = p_wip_entity_id
1706: AND organization_id = p_organization_id
1707: ORDER BY operation_seq_num ;
1708:

Line 1754: FROM WIP_OPERATIONS

1750:
1751: begin
1752: SELECT min(operation_seq_num)
1753: INTO l_first_operation
1754: FROM WIP_OPERATIONS
1755: WHERE wip_entity_id = p_wip_entity_id
1756: AND organization_id = p_organization_id;
1757: exception
1758: when no_data_found then

Line 1779: WIP_OPERATIONS_UTILITIES.Update_Operationless_Reqs

1775:
1776: /* Fix for bug 4273638: Since the operation being added is the
1777: first operation,move the components currently under op-seq 1
1778: to the operation being added */
1779: WIP_OPERATIONS_UTILITIES.Update_Operationless_Reqs
1780: (p_wip_entity_id,
1781: p_organization_id,
1782: cur_oper.operation_seq_num,
1783: NULL, /* repetitive schedule id */

Line 1791: from wip_operations

1787:
1788: ELSIF l_first_operation > cur_oper.operation_seq_num THEN
1789:
1790: select quantity_in_queue into l_quantity_in_queue
1791: from wip_operations
1792: where wip_entity_id = p_wip_entity_id
1793: and organization_id = p_organization_id
1794: and operation_seq_num = l_first_operation;
1795:

Line 1798: update wip_operations

1794: and operation_seq_num = l_first_operation;
1795:
1796: -- need to erase the quantity from the current 1st op or
1797: -- else we are creating duplicate qty
1798: update wip_operations
1799: set quantity_in_queue = 0,
1800: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
1801: where wip_entity_id = p_wip_entity_id
1802: and organization_id = p_organization_id

Line 1811: wip_operations_pkg.add(p_organization_id,

1807:
1808: END IF;
1809:
1810: IF cur_oper.standard_operation_id is not null THEN
1811: wip_operations_pkg.add(p_organization_id,
1812: p_wip_entity_id,
1813: cur_oper.operation_seq_num,
1814: cur_oper.standard_operation_id,
1815: cur_oper.department_id);

Line 1816: UPDATE WIP_OPERATIONS

1812: p_wip_entity_id,
1813: cur_oper.operation_seq_num,
1814: cur_oper.standard_operation_id,
1815: cur_oper.department_id);
1816: UPDATE WIP_OPERATIONS
1817: SET last_update_date = sysdate,/*BUG 6721823*/
1818: last_updated_by = NVL(cur_oper.last_updated_by,last_updated_by),
1819: creation_date = NVL(cur_oper.creation_date,creation_date),
1820: created_by = NVL(cur_oper.created_by, created_by),

Line 1912: FROM wip_operations

1908: /* For Enhancement#2864382. Calculate cumulative_scrap_quantity for this operation */
1909: IF cur_oper.operation_seq_num > l_first_operation THEN
1910: SELECT SUM(quantity_scrapped)
1911: INTO l_scrap_qty
1912: FROM wip_operations
1913: WHERE organization_id = p_organization_id
1914: AND wip_entity_id = p_wip_entity_id
1915: AND operation_seq_num < cur_oper.operation_seq_num;
1916: END IF;

Line 1919: INSERT INTO WIP_OPERATIONS

1915: AND operation_seq_num < cur_oper.operation_seq_num;
1916: END IF;
1917:
1918:
1919: INSERT INTO WIP_OPERATIONS
1920: ( wip_entity_id,
1921: operation_seq_num,
1922: organization_id,
1923: last_update_date,

Line 2047: UPDATE WIP_OPERATIONS

2043: FOR each_oper IN OPERATIONS(p_wip_entity_id,p_organization_id) LOOP
2044:
2045: IF previous_operation = 0 then
2046:
2047: UPDATE WIP_OPERATIONS
2048: SET PREVIOUS_OPERATION_SEQ_NUM = NULL,
2049: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2050: WHERE wip_entity_id = p_wip_entity_id
2051: AND organization_id = p_organization_id

Line 2058: UPDATE WIP_OPERATIONS

2054: previous_operation := each_oper.operation_seq_num;
2055:
2056: ELSE
2057:
2058: UPDATE WIP_OPERATIONS
2059: SET PREVIOUS_OPERATION_SEQ_NUM = previous_operation,
2060: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2061: WHERE wip_entity_id = p_wip_entity_id
2062: AND organization_id = p_organization_id

Line 2065: UPDATE WIP_OPERATIONS

2061: WHERE wip_entity_id = p_wip_entity_id
2062: AND organization_id = p_organization_id
2063: AND operation_seq_num = each_oper.operation_seq_num;
2064:
2065: UPDATE WIP_OPERATIONS
2066: SET NEXT_OPERATION_SEQ_NUM = each_oper.operation_seq_num,
2067: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2068: WHERE wip_entity_id = p_wip_entity_id
2069: AND organization_id = p_organization_id

Line 2112: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO

2108: WJDI.attribute4, WJDI.attribute5,
2109: WJDI.attribute6, WJDI.attribute7, WJDI.attribute8, WJDI.attribute9, WJDI.attribute10,
2110: WJDI.attribute11, WJDI.attribute12, WJDI.attribute13, WJDI.attribute14, WJDI.attribute15,
2111: WO.standard_operation_id curr_standard_operation_id
2112: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO
2113: WHERE group_id = p_group_id
2114: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION
2115: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2116: AND WJDI.wip_entity_id = p_wip_entity_id

Line 2160: UPDATE WIP_OPERATIONS

2156: P_DEPARTMENT_ID => cur_oper.department_id,
2157: P_ORGANIZATION_ID => P_ORGANIZATION_ID
2158: );
2159:
2160: UPDATE WIP_OPERATIONS
2161: SET last_update_date = sysdate,/*BUG 6721823*/
2162: last_updated_by = NVL(cur_oper.last_updated_by,last_updated_by),
2163: creation_date = NVL(cur_oper.creation_date,creation_date),
2164: created_by = NVL(cur_oper.created_by, created_by),

Line 2212: WIP_OPERATIONS_UTILITIES.Update_Reqs

2208: and organization_id = p_organization_id
2209: and operation_seq_num = cur_oper.operation_seq_num;
2210:
2211: /* Bug 5026773 - Update Material Rquirements to reflect the changed operation. */
2212: WIP_OPERATIONS_UTILITIES.Update_Reqs
2213: (p_wip_entity_id,
2214: p_organization_id,
2215: cur_oper.operation_seq_num,
2216: NULL, /* repetitive schedule id */

Line 2251: FROM WIP_OPERATIONS

2247: -- Update date_required for Components on this Operation
2248: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
2249: SET WRO.DATE_REQUIRED =
2250: (SELECT FIRST_UNIT_START_DATE
2251: FROM WIP_OPERATIONS
2252: WHERE WIP_ENTITY_ID = p_wip_entity_id
2253: AND OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM)
2254: AND ORGANIZATION_ID = p_organization_id
2255: ),

Line 2315: from wip_operations wo

2311: )
2312: */
2313: and wjdi.operation_seq_num =
2314: (select wo.operation_seq_num
2315: from wip_operations wo
2316: where wo.wip_entity_id = p_wip_entity_id
2317: and wo.organization_id = p_organization_id
2318: and wo.operation_seq_num = wjdi.operation_seq_num
2319: and (wo.first_unit_start_date >

Line 2366: from wip_operations wo

2362: and (wjdi.first_unit_start_date is not null or
2363: wjdi.last_unit_completion_date is not null)
2364: and wjdi.operation_seq_num =
2365: (select wo.operation_seq_num
2366: from wip_operations wo
2367: where wo.wip_entity_id = p_wip_entity_id
2368: and wo.organization_id = p_organization_id
2369: and wo.operation_seq_num = wjdi.operation_seq_num
2370: and (wo.first_unit_start_date >