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.CTO_WIP_WRAPPER dependencies on OE_ORDER_LINES_ALL

Line 118: | hece, joined oe_order_lines_all and got the ship_from _org_id

Line 176: UPDATE oe_order_lines_all oel

172:
173: BEGIN
174:
175:
176: UPDATE oe_order_lines_all oel
177: SET oel.program_id = null
178: WHERE oel.line_id = p_line_id
179: AND oel.program_id = -99;
180:

Line 396: ' oe_order_lines_all OEL, '||

392: ' nvl(oel.org_id,-1) org_id, ' ||
393: ' oel.ato_line_id ato_line_id, '||
394: ' oel.inventory_item_id inventory_item_id '||
395: 'from '||
396: ' oe_order_lines_all OEL, '||
397: ' wf_item_activity_statuses WAS, '||
398: ' wf_process_activities WPA, '||
399: ' mtl_system_items MSI ';
400: else

Line 419: ' oe_order_lines_all OEL, '||

415: ' oel.inventory_item_id inventory_item_id '||
416: 'from '||
417: ' wf_process_activities WPA, '||
418: ' wf_item_activity_statuses WAS, '||
419: ' oe_order_lines_all OEL, '||
420: ' mtl_system_items MSI ';
421: end if;
422:
423:

Line 494: ' from oe_order_lines_all oelc '||

490: if (l_line_id is NOT NULL) then
491: sql_stmt := sql_stmt ||
492: 'and oel.line_id in '||
493: '(select oelc.line_id '||
494: ' from oe_order_lines_all oelc '||
495: ' where (oelc.ato_line_id = :l_line_id '||--5108885
496: 'and oelc.item_type_code = ''CONFIG'') '||
497: 'or (oelc.line_id = :l_line_id '||
498: 'and oelc.item_type_code = ''STANDARD'' ' ||

Line 853: FROM OE_ORDER_LINES_ALL

849:
850: begin
851: SELECT ship_from_org_id
852: INTO l_ship_from_org_id
853: FROM OE_ORDER_LINES_ALL
854: WHERE line_id = WorkOrder_Rec.ato_line_id --- bug fix 5207010 . We should lock based on ATO line id
855: and (GET_NOTINV_QTY(WorkOrder_Rec.line_id) - GET_RESERVED_QTY(WorkOrder_Rec.line_id)) > 0
856: FOR UPDATE NOWAIT; -- bugfix 2388802: lock the row which is really eligible
857: l_inventory_item_id := WorkOrder_Rec.inventory_item_id;

Line 1034: from oe_order_lines_all oel

1030: l_stmt_num := 6;
1031:
1032: select nvl(oel.dep_plan_required_flag,'N')
1033: into l_dep_plan_flag
1034: from oe_order_lines_all oel
1035: where oel.line_id = WorkOrder_Rec.line_id;
1036:
1037: IF PG_DEBUG <> 0 THEN
1038: OE_DEBUG_PUB.add('get_order_lines: ' || 'l_dep_plan_flag::'||l_dep_plan_flag, 2);

Line 1209: oe_order_lines_all oel

1205:
1206: select dj.wip_entity_id, we.wip_entity_name
1207: into l_wip_entity_id, l_job_name
1208: from wip_discrete_jobs dj, wip_entities we,
1209: oe_order_lines_all oel
1210: where dj.wip_entity_id = we.wip_entity_id
1211: and dj.source_line_id = l_line_id
1212: and dj.source_code = 'WICDOL'
1213: --bugfix 2885568 to remove full table scan on wip_discrete_jobs

Line 1294: oe_order_lines_all

1290:
1291: /*****************************************************************************
1292: Procedure: reserve_work_order
1293: Parameters: p_model_line_id - line id of the configuration item in
1294: oe_order_lines_all
1295: p_wip_seq - group id to be used in interface table
1296: x_error_message - error message if insert fails
1297: x_message_name - name of error message if insert
1298: fails

Line 1382: oe_order_lines_all oel,

1378: -- 2620282: Selecting bom revision info
1379: decode( nvl(msi.revision_qty_control_code , 1 ) , 1, NULL , wei.bom_revision) bom_revision,
1380: oel.org_id -- bugfix 3014000
1381: from wip_job_schedule_interface wei,
1382: oe_order_lines_all oel,
1383: mtl_sales_orders mso,
1384: oe_order_headers_all oeh,
1385: --oe_order_types_v oet
1386: oe_transaction_types_tl oet,

Line 1658: UPDATE oe_order_lines_all

1654:
1655: end if; /* reservation status not successful */
1656:
1657: /* Bugfix 2105156 : Release the manual lock */
1658: UPDATE oe_order_lines_all
1659: SET program_id = null
1660: WHERE line_id = WorkOrder_Rec.line_id
1661: AND program_id = -99;
1662:

Line 1669: update oe_order_lines_all

1665: -- begin bugfix 3136206
1666: if resv_counter = 0 then
1667: oe_debug_pub.add('Warning: No reservations made. Check for errors in WJSI');
1668: -- unlock the lines. Update the program_id to null.
1669: update oe_order_lines_all
1670: set program_id = null
1671: where program_id = -99
1672: and line_id in (select wei.source_line_id
1673: from wip_job_schedule_interface wei

Line 1756: oe_order_lines_all oel,

1752: null,
1753: null)),0)
1754: from mtl_reservations mr,
1755: oe_order_headers_all oeh,
1756: oe_order_lines_all oel,
1757: mtl_system_items msi --bugfix 2074290: added msi
1758: where oel.line_id = pLineId
1759: and oel.header_id = oeh.header_id
1760: and mr.demand_source_line_id = oel.line_id

Line 1776: oe_order_lines_all oel

1772:
1773: cursor c_wjsi_qty is
1774: select nvl(sum(wjs.start_quantity), 0)
1775: from wip_job_schedule_interface wjs,
1776: oe_order_lines_all oel
1777: where oel.line_id = pLineId
1778: and wjs.source_line_id = oel.line_id
1779: and (wjs.process_status = WIP_CONSTANTS.PENDING
1780: or wjs.process_status = WIP_CONSTANTS.RUNNING

Line 1899: oe_order_lines_all oel,

1895: null)),
1896: 'Y', nvl(sum(wdd.requested_quantity), 0) )
1897: into l_quantity
1898: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
1899: oe_order_lines_all oel,
1900: mtl_system_items msi
1901: where oel.line_id = pLineId
1902: and oel.inventory_item_id = msi.inventory_item_id
1903: and oel.ship_from_org_id = msi.organization_id