DBA Data[Home] [Help]

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 499: from oe_order_lines_all oel,

495: ,oel.request_date
496: ,oel.ordered_quantity2 --opm
497: ,oel.ordered_quantity_uom2 --opm
498: ,oel.preferred_grade --opm
499: from oe_order_lines_all oel,
500: oe_order_headers_all oeh
501: where oel.header_id = oeh.header_id
502: and oel.line_id = p_cursor_line_id
503: FOR UPDATE OF oel.line_id;

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

503: FOR UPDATE OF oel.line_id;
504:
505: so_line oe_lines_cur%rowtype;
506:
507: TYPE line_id_tab_type is table of oe_order_lines_all.line_id%type;
508: line_id_tab line_id_tab_type;
509: c_batch_size number := 1000;
510: tab_index number;
511:

Line 1311: l_project_id oe_order_lines_all.project_id%type;

1307: WHERE user_id = i_created_by;
1308:
1309: l_operating_unit Number;
1310:
1311: l_project_id oe_order_lines_all.project_id%type;
1312: l_task_id oe_order_lines_all.task_id%type;
1313:
1314: --bugfix 4068164
1315: l_item_revision VARCHAR2(3) := null;

Line 1312: l_task_id oe_order_lines_all.task_id%type;

1308:
1309: l_operating_unit Number;
1310:
1311: l_project_id oe_order_lines_all.project_id%type;
1312: l_task_id oe_order_lines_all.task_id%type;
1313:
1314: --bugfix 4068164
1315: l_item_revision VARCHAR2(3) := null;
1316: l_ato_line_id NUMBER;

Line 1475: and table_name = 'OE_ORDER_LINES_ALL'

1471: l_stmt_num := 80;
1472: select count(*) into l_chk_col
1473: from all_tab_columns
1474: where owner = l_customer_schema --bugfix 3871646 --'ONT'
1475: and table_name = 'OE_ORDER_LINES_ALL'
1476: and column_name = 'USER_ITEM_DESCRIPTION';
1477:
1478: If l_chk_col > 0 then
1479: sql_stmt := 'SELECT substrb(oel.user_item_description,1,240)'

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

1476: and column_name = 'USER_ITEM_DESCRIPTION';
1477:
1478: If l_chk_col > 0 then
1479: sql_stmt := 'SELECT substrb(oel.user_item_description,1,240)'
1480: ||' FROM oe_order_lines_all oel , mtl_system_items msi'
1481: ||' WHERE oel.ship_from_org_id = msi.organization_id'
1482: ||' AND oel.inventory_item_id = msi.inventory_item_id'
1483: ||' AND oel.line_id = :p_interface_source_line_id'
1484: ||' AND msi.organization_id = :p_destination_org_id'

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

1503: else
1504: l_user_item_desc := NULL;
1505:
1506: IF PG_DEBUG <> 0 THEN
1507: oe_debug_pub.add('OE_ORDER_LINES_ALL does not have column USER_ITEM_DESCRIPTION , l_chk_col: ' ||
1508: to_char(l_chk_col),1);
1509: END IF;
1510:
1511: end if;

Line 1538: from oe_order_lines_all

1534: Select decode(project_id,-1,NULL,project_id),
1535: decode(task_id,-1,NULL,task_id)
1536: into l_project_id,
1537: l_task_id
1538: from oe_order_lines_all
1539: where line_id = p_interface_source_line_id;
1540: Exception
1541: WHen no_data_found THEN
1542: null;

Line 1608: from oe_order_lines_all

1604: if FND_PROFILE.value('INV_PURCHASING_BY_REVISION') = 1
1605: and p_req_interface_input_data.source_type <> 1 then
1606: l_stmt_num := 130;
1607: select ato_line_id into l_ato_line_id
1608: from oe_order_lines_all
1609: where line_id = p_interface_source_line_id;
1610:
1611: if l_ato_line_id = p_interface_source_line_id then
1612: Begin

Line 1993: from oe_order_lines_all

1989: p_line_id NUMBER) is
1990: select line_id,
1991: ordered_quantity,
1992: inventory_item_id
1993: from oe_order_lines_all
1994: where line_id = p_line_id;
1995:
1996: -- define the local parameters
1997: l_inv_qty NUMBER;

Line 4046: from oe_order_lines_all oel,

4042: END IF;
4043:
4044: OPEN pprollup_oe_cur FOR
4045: SELECT oel.line_id, oel.inventory_item_id,oel.ato_line_id
4046: from oe_order_lines_all oel,
4047: oe_order_headers_all oeh,
4048: mtl_system_items msi
4049: where oel.inventory_item_id = msi.inventory_item_id
4050: and oel.ship_from_org_id = msi.organization_id

Line 4790: 'from oe_order_lines_all oel,'||

4786: -- Added it to the where clause along with PO_REQ_REQUESTED clause
4787: drive_mark := 0;
4788: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, status, inventory_item_id)'||
4789: 'select oel.line_id, oel.org_id, 1, 0 '||
4790: 'from oe_order_lines_all oel,'||
4791: ' mtl_system_items msi,'||
4792: ' wf_item_activity_statuses was,'||
4793: ' wf_process_activities WPA ';
4794:

Line 4860: 'from oe_order_lines_all oelc '||

4856: /* Given a Order Line ID */
4857: if p_sales_order_line_id is not null then
4858: drive_mark := drive_mark + 2;
4859: sql_stmt := sql_stmt ||' and oel.line_id in (select oelc.line_id '||
4860: 'from oe_order_lines_all oelc '||
4861: 'where oelc.ato_line_id = :p_sales_order_line_id '||
4862: 'and (oelc.item_type_code = ''CONFIG'' '||
4863: ' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||
4864: ' and ato_line_id = line_id)) '||

Line 5049: FROM oe_order_lines_all

5045: SELECT end_customer_id,
5046: end_customer_site_use_id
5047: INTO l_cust_id,
5048: l_cust_site_id
5049: FROM oe_order_lines_all
5050: WHERE line_id = p_interface_source_line_id;
5051:
5052: IF PG_DEBUG <> 0 THEN
5053: oe_debug_pub.add('Get_opm_charge_account: ' || 'Customer ID : '||to_char(l_cust_id),3);