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 390: wip_operations wo

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

Line 622: from wip_operations

618: END IF;
619:
620: select first_unit_start_date,last_unit_completion_date
621: into l_first_unit_start_date,l_last_unit_completion_date
622: from wip_operations
623: where wip_entity_id = p_wip_entity_id
624: AND organization_id = p_organization_id
625: AND operation_seq_num = cur_row.operation_seq_num;
626:

Line 630: UPDATE wip_operations

626:
627: IF (cur_row.start_date is not null
628: AND cur_row.start_date < l_first_unit_start_date)
629: THEN
630: UPDATE wip_operations
631: set first_unit_start_date = cur_row.start_date,
632: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
633: where wip_entity_id = p_wip_entity_id
634: AND organization_id = p_organization_id

Line 640: UPDATE wip_operations

636: END IF;
637: IF (cur_row.completion_date is not null
638: AND cur_row.completion_date > l_last_unit_completion_date)
639: THEN
640: UPDATE wip_operations
641: set last_unit_completion_date = cur_row.completion_date,
642: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
643: where wip_entity_id = p_wip_entity_id
644: AND organization_id = p_organization_id

Line 1726: FROM wip_operations

1722:
1723: CURSOR operations(p_wip_entity_id number,
1724: p_organization_id number) IS
1725: SELECT operation_seq_num
1726: FROM wip_operations
1727: WHERE wip_entity_id = p_wip_entity_id
1728: AND organization_id = p_organization_id
1729: ORDER BY operation_seq_num ;
1730:

Line 1780: FROM WIP_OPERATIONS

1776:
1777: begin
1778: SELECT min(operation_seq_num)
1779: INTO l_first_operation
1780: FROM WIP_OPERATIONS
1781: WHERE wip_entity_id = p_wip_entity_id
1782: AND organization_id = p_organization_id;
1783: exception
1784: when no_data_found then

Line 1897: WIP_OPERATIONS_UTILITIES.Update_Operationless_Reqs

1893:
1894: /* Fix for bug 4273638: Since the operation being added is the
1895: first operation,move the components currently under op-seq 1
1896: to the operation being added */
1897: WIP_OPERATIONS_UTILITIES.Update_Operationless_Reqs
1898: (p_wip_entity_id,
1899: p_organization_id,
1900: cur_oper.operation_seq_num,
1901: NULL, /* repetitive schedule id */

Line 1909: from wip_operations

1905:
1906: ELSIF l_first_operation > cur_oper.operation_seq_num THEN
1907:
1908: select quantity_in_queue into l_quantity_in_queue
1909: from wip_operations
1910: where wip_entity_id = p_wip_entity_id
1911: and organization_id = p_organization_id
1912: and operation_seq_num = l_first_operation;
1913:

Line 1916: update wip_operations

1912: and operation_seq_num = l_first_operation;
1913:
1914: -- need to erase the quantity from the current 1st op or
1915: -- else we are creating duplicate qty
1916: update wip_operations
1917: set quantity_in_queue = 0,
1918: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
1919: where wip_entity_id = p_wip_entity_id
1920: and organization_id = p_organization_id

Line 1929: wip_operations_pkg.add(p_organization_id,

1925:
1926: END IF;
1927:
1928: IF cur_oper.standard_operation_id is not null THEN
1929: wip_operations_pkg.add(p_organization_id,
1930: p_wip_entity_id,
1931: cur_oper.operation_seq_num,
1932: cur_oper.standard_operation_id,
1933: cur_oper.department_id);

Line 1934: UPDATE WIP_OPERATIONS

1930: p_wip_entity_id,
1931: cur_oper.operation_seq_num,
1932: cur_oper.standard_operation_id,
1933: cur_oper.department_id);
1934: UPDATE WIP_OPERATIONS
1935: SET last_update_date = sysdate,/*BUG 6721823*/
1936: last_updated_by = NVL(cur_oper.last_updated_by,last_updated_by),
1937: creation_date = NVL(cur_oper.creation_date,creation_date),
1938: created_by = NVL(cur_oper.created_by, created_by),

Line 2030: FROM wip_operations

2026: /* For Enhancement#2864382. Calculate cumulative_scrap_quantity for this operation */
2027: IF cur_oper.operation_seq_num > l_first_operation THEN
2028: SELECT SUM(quantity_scrapped)
2029: INTO l_scrap_qty
2030: FROM wip_operations
2031: WHERE organization_id = p_organization_id
2032: AND wip_entity_id = p_wip_entity_id
2033: AND operation_seq_num < cur_oper.operation_seq_num;
2034: END IF;

Line 2037: INSERT INTO WIP_OPERATIONS

2033: AND operation_seq_num < cur_oper.operation_seq_num;
2034: END IF;
2035:
2036:
2037: INSERT INTO WIP_OPERATIONS
2038: ( wip_entity_id,
2039: operation_seq_num,
2040: organization_id,
2041: last_update_date,

Line 2165: UPDATE WIP_OPERATIONS

2161: FOR each_oper IN OPERATIONS(p_wip_entity_id,p_organization_id) LOOP
2162:
2163: IF previous_operation = 0 then
2164:
2165: UPDATE WIP_OPERATIONS
2166: SET PREVIOUS_OPERATION_SEQ_NUM = NULL,
2167: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2168: WHERE wip_entity_id = p_wip_entity_id
2169: AND organization_id = p_organization_id

Line 2176: UPDATE WIP_OPERATIONS

2172: previous_operation := each_oper.operation_seq_num;
2173:
2174: ELSE
2175:
2176: UPDATE WIP_OPERATIONS
2177: SET PREVIOUS_OPERATION_SEQ_NUM = previous_operation,
2178: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2179: WHERE wip_entity_id = p_wip_entity_id
2180: AND organization_id = p_organization_id

Line 2183: UPDATE WIP_OPERATIONS

2179: WHERE wip_entity_id = p_wip_entity_id
2180: AND organization_id = p_organization_id
2181: AND operation_seq_num = each_oper.operation_seq_num;
2182:
2183: UPDATE WIP_OPERATIONS
2184: SET NEXT_OPERATION_SEQ_NUM = each_oper.operation_seq_num,
2185: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2186: WHERE wip_entity_id = p_wip_entity_id
2187: AND organization_id = p_organization_id

Line 2219: /Fix for But 8784056 (FP of 8704687). format the date from WJDI without second before update WIP_OPERATIONS, to make it consistant with other files./

2215: p_wip_entity_id number,
2216: p_organization_id number) IS
2217: SELECT WJDI.parent_header_id, WJDI.operation_seq_num, WJDI.standard_operation_id,
2218: WJDI.department_id, WJDI.description ,
2219: /*Fix for But 8784056 (FP of 8704687). format the date from WJDI without second before update WIP_OPERATIONS, to make it consistant with other files.*/
2220: -- No need to truncate dates. Bug 13045227.
2221: WJDI.first_unit_start_date first_unit_start_date,
2222: WJDI.first_unit_completion_date first_unit_completion_date,
2223: WJDI.last_unit_start_date last_unit_start_date,

Line 2235: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO

2231: WJDI.attribute4, WJDI.attribute5,
2232: WJDI.attribute6, WJDI.attribute7, WJDI.attribute8, WJDI.attribute9, WJDI.attribute10,
2233: WJDI.attribute11, WJDI.attribute12, WJDI.attribute13, WJDI.attribute14, WJDI.attribute15,
2234: WO.standard_operation_id curr_standard_operation_id
2235: FROM WIP_JOB_DTLS_INTERFACE WJDI, WIP_OPERATIONS WO
2236: WHERE group_id = p_group_id
2237: AND WJDI.process_phase = WIP_CONSTANTS.ML_VALIDATION
2238: AND WJDI.process_status IN (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2239: AND WJDI.wip_entity_id = p_wip_entity_id

Line 2283: UPDATE WIP_OPERATIONS

2279: P_DEPARTMENT_ID => cur_oper.department_id,
2280: P_ORGANIZATION_ID => P_ORGANIZATION_ID
2281: );
2282:
2283: UPDATE WIP_OPERATIONS
2284: SET last_update_date = sysdate,/*BUG 6721823*/
2285: /*FP BUG 13406111 :BUG 12814417 @Start */
2286: last_updated_by = fnd_global.user_id,
2287: -- creation_date = cur_row.creation_date,

Line 2335: WIP_OPERATIONS_UTILITIES.Update_Reqs

2331: and organization_id = p_organization_id
2332: and operation_seq_num = cur_oper.operation_seq_num;
2333:
2334: /* Bug 5026773 - Update Material Rquirements to reflect the changed operation. */
2335: WIP_OPERATIONS_UTILITIES.Update_Reqs
2336: (p_wip_entity_id,
2337: p_organization_id,
2338: cur_oper.operation_seq_num,
2339: NULL, /* repetitive schedule id */

Line 2374: FROM WIP_OPERATIONS

2370: -- Update date_required for Components on this Operation
2371: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
2372: SET WRO.DATE_REQUIRED =
2373: (SELECT FIRST_UNIT_START_DATE
2374: FROM WIP_OPERATIONS
2375: WHERE WIP_ENTITY_ID = p_wip_entity_id
2376: AND OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM)
2377: AND ORGANIZATION_ID = p_organization_id
2378: ),

Line 2440: from wip_operations wo

2436: )
2437: */
2438: and wjdi.operation_seq_num =
2439: (select wo.operation_seq_num
2440: from wip_operations wo
2441: where wo.wip_entity_id = p_wip_entity_id
2442: and wo.organization_id = p_organization_id
2443: and wo.operation_seq_num = wjdi.operation_seq_num
2444: and (wo.first_unit_start_date >

Line 2492: from wip_operations wo

2488: and (wjdi.first_unit_start_date is not null or
2489: wjdi.last_unit_completion_date is not null)
2490: and wjdi.operation_seq_num =
2491: (select wo.operation_seq_num
2492: from wip_operations wo
2493: where wo.wip_entity_id = p_wip_entity_id
2494: and wo.organization_id = p_organization_id
2495: and wo.operation_seq_num = wjdi.operation_seq_num
2496: and (wo.first_unit_start_date >