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_AUTO_PROCURE_PK dependencies on OE_ORDER_LINES_ALL

Line 49: | oe_order_lines_all to po_requisitions_interface |

45: |
46: | |
47: | |
48: | 27-Nov-2002 : Kundan Sarkar Fix 2503104 Passing user_item_description from |
49: | oe_order_lines_all to po_requisitions_interface |
50: | |
51: |
52: | 12-DEC-2002 Kiran Konada added code for MLSUPPLY feature
53: | added a new parameter to proc populate_req_interface

Line 63: | related to USER_ITEM_DESCRIPTION column in OE_ORDER_LINES_ALL |

59: | |
60: | |
61: | 23-Jan-2003 : Kundan Sarkar Fix 2503104 Revert earlier fix and introduce |
62: | dyanamic SQL to avoid compile time dependency of OM fix |
63: | related to USER_ITEM_DESCRIPTION column in OE_ORDER_LINES_ALL |
64: |
65: | 31-JAN-2003 Kiran Konada bugfix 2780392
66: | Addded a IF condition to check for null value passed in
67: | interface_source_line_id value passed to populate_req_interafce

Line 124: | from oe_order_lines_all into bom_cto_order_lines_temp. Loop

120: |Jul 29 2004 Kaza
121: | Forward ported ct bugs 3590305 and 3599860.Significant changes
122: | to auto_create_purchase_req_cr. Please refer to the bug texts
123: | for details. In short, take a snapshot of eligible order lines
124: | from oe_order_lines_all into bom_cto_order_lines_temp. Loop
125: | thru the temp 1000 records at a time, lock each line
126: | individually, process and commit.
127: |
128: |Oct 26,2004 Kkonada

Line 555: from oe_order_lines_all oel,

551: --Bugfix 13500057: For debugging purposes.
552: ,oel.shipped_quantity
553: ,oel.flow_status_code
554: ,oel.shipping_interfaced_flag
555: from oe_order_lines_all oel,
556: oe_order_headers_all oeh
557: where oel.header_id = oeh.header_id
558: and oel.line_id = p_cursor_line_id
559: FOR UPDATE OF oel.line_id;

Line 571: --TYPE line_id_tab_type is table of oe_order_lines_all.line_id%type;

567: -- pdube
568: --
569: TYPE eligible_lines_rec_tab_typ is table of eligible_lines_cur%rowtype index by binary_integer;
570: line_id_tab eligible_lines_rec_tab_typ;
571: --TYPE line_id_tab_type is table of oe_order_lines_all.line_id%type;
572: --line_id_tab line_id_tab_type;
573: c_batch_size number := 1000;
574: tab_index number;
575:

Line 1623: l_project_id oe_order_lines_all.project_id%type;

1619: WHERE user_id = i_created_by;
1620:
1621: l_operating_unit Number;
1622:
1623: l_project_id oe_order_lines_all.project_id%type;
1624: l_task_id oe_order_lines_all.task_id%type;
1625:
1626: --bugfix 4068164
1627: l_item_revision VARCHAR2(3) := null;

Line 1624: l_task_id oe_order_lines_all.task_id%type;

1620:
1621: l_operating_unit Number;
1622:
1623: l_project_id oe_order_lines_all.project_id%type;
1624: l_task_id oe_order_lines_all.task_id%type;
1625:
1626: --bugfix 4068164
1627: l_item_revision VARCHAR2(3) := null;
1628: l_ato_line_id NUMBER;

Line 1788: and table_name = 'OE_ORDER_LINES_ALL'

1784: /*
1785: select count(*) into l_chk_col
1786: from all_tab_columns
1787: where owner = l_customer_schema --bugfix 3871646 --'ONT'
1788: and table_name = 'OE_ORDER_LINES_ALL'
1789: and column_name = 'USER_ITEM_DESCRIPTION';
1790: */
1791: --bug 15835553
1792: SELECT count(*) INTO l_chk_col

Line 1797: AND syn.synonym_name = 'OE_ORDER_LINES_ALL'

1793: FROM user_synonyms syn,
1794: dba_tab_columns col
1795: WHERE col.owner =syn.table_owner
1796: AND col.table_name = syn.table_name
1797: AND syn.synonym_name = 'OE_ORDER_LINES_ALL'
1798: AND col.column_name = 'USER_ITEM_DESCRIPTION'
1799: and col.owner = l_customer_schema;
1800:
1801: If l_chk_col > 0 then

Line 1803: ||' FROM oe_order_lines_all oel , mtl_system_items msi'

1799: and col.owner = l_customer_schema;
1800:
1801: If l_chk_col > 0 then
1802: sql_stmt := 'SELECT substrb(oel.user_item_description,1,240)'
1803: ||' FROM oe_order_lines_all oel , mtl_system_items msi'
1804: ||' WHERE oel.ship_from_org_id = msi.organization_id'
1805: ||' AND oel.inventory_item_id = msi.inventory_item_id'
1806: ||' AND oel.line_id = :p_interface_source_line_id'
1807: ||' AND msi.organization_id = :p_destination_org_id'

Line 1830: oe_debug_pub.add('OE_ORDER_LINES_ALL does not have column USER_ITEM_DESCRIPTION , l_chk_col: ' ||

1826: else
1827: l_user_item_desc := NULL;
1828:
1829: IF PG_DEBUG <> 0 THEN
1830: oe_debug_pub.add('OE_ORDER_LINES_ALL does not have column USER_ITEM_DESCRIPTION , l_chk_col: ' ||
1831: to_char(l_chk_col),1);
1832: END IF;
1833:
1834: end if;

Line 1861: from oe_order_lines_all

1857: Select decode(project_id,-1,NULL,project_id),
1858: decode(task_id,-1,NULL,task_id)
1859: into l_project_id,
1860: l_task_id
1861: from oe_order_lines_all
1862: where line_id = p_interface_source_line_id;
1863: Exception
1864: WHen no_data_found THEN
1865: null;

Line 1931: from oe_order_lines_all

1927: if FND_PROFILE.value('INV_PURCHASING_BY_REVISION') = 1
1928: and p_req_interface_input_data.source_type <> 1 then
1929: l_stmt_num := 130;
1930: select ato_line_id into l_ato_line_id
1931: from oe_order_lines_all
1932: where line_id = p_interface_source_line_id;
1933:
1934: if l_ato_line_id = p_interface_source_line_id then
1935: Begin

Line 2327: from oe_order_lines_all oel

2323: */
2324:
2325: select nvl(oel.shipped_quantity, 0)
2326: into l_oel_shipped_qty
2327: from oe_order_lines_all oel
2328: where oel.line_id = p_interface_source_line_id;
2329:
2330: IF PG_DEBUG <> 0 THEN
2331: oe_debug_pub.add('get_new_order_qty: ' || 'The Order Line Shipped Quantity: '|| to_char(l_oel_shipped_qty));

Line 2378: from oe_order_lines_all

2374: p_line_id NUMBER) is
2375: select line_id,
2376: ordered_quantity,
2377: inventory_item_id
2378: from oe_order_lines_all
2379: where line_id = p_line_id;
2380:
2381: -- define the local parameters
2382: l_inv_qty NUMBER;

Line 4456: from oe_order_lines_all oel,

4452: END IF;
4453:
4454: OPEN pprollup_oe_cur FOR
4455: SELECT oel.line_id, oel.inventory_item_id,oel.ato_line_id
4456: from oe_order_lines_all oel,
4457: oe_order_headers_all oeh,
4458: mtl_system_items msi
4459: where oel.inventory_item_id = msi.inventory_item_id
4460: and oel.ship_from_org_id = msi.organization_id

Line 5202: 'from oe_order_lines_all oel,'||

5198: -- Added it to the where clause along with PO_REQ_REQUESTED clause
5199: drive_mark := 0;
5200: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||
5201: 'select oel.line_id, oel.org_id, 1, 0 '||
5202: 'from oe_order_lines_all oel,'||
5203: ' mtl_system_items msi,'||
5204: ' wf_item_activity_statuses was,'||
5205: ' wf_process_activities WPA ';
5206:

Line 5279: 'from oe_order_lines_all oelc '||

5275: /* Given a Order Line ID */
5276: if p_sales_order_line_id is not null then
5277: drive_mark := drive_mark + 2;
5278: sql_stmt := sql_stmt ||' and oel.line_id in (select oelc.line_id '||
5279: 'from oe_order_lines_all oelc '||
5280: 'where oelc.ato_line_id = :p_sales_order_line_id '||
5281: 'and (oelc.item_type_code = ''CONFIG'' '||
5282: --Adding INCLUDED item type code for SUN ER#9793792
5283: --' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||

Line 5472: FROM oe_order_lines_all

5468: SELECT end_customer_id,
5469: end_customer_site_use_id
5470: INTO l_cust_id,
5471: l_cust_site_id
5472: FROM oe_order_lines_all
5473: WHERE line_id = p_interface_source_line_id;
5474:
5475: IF PG_DEBUG <> 0 THEN
5476: oe_debug_pub.add('Get_opm_charge_account: ' || 'Customer ID : '||to_char(l_cust_id),3);