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

Line 278: select invoice_to_org_id from oe_order_lines_all where line_id = l_lineId;

274: ,x_site_use_id OUT NOCOPY NUMBER)
275: IS
276:
277: cursor c_get_line_Info(l_lineId Number) is
278: select invoice_to_org_id from oe_order_lines_all where line_id = l_lineId;
279:
280:
281: p_line_ids varchar2(3000) := null;
282: l_line_id_query varchar2(3000);

Line 347: select * from oe_order_lines_all

343: x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
344: )
345: IS
346: cursor c_get_lineInfo(l_lineid varchar2,l_ordhdrId varchar2,l_rethdrId number) is
347: select * from oe_order_lines_all
348: where header_id = l_rethdrId
349: and return_attribute2 = l_lineid
350: and return_attribute1 = l_ordhdrId
351: and line_category_code= 'RETURN';

Line 430: SELECT salesrep_id from OE_ORDER_LINES_ALL WHERE line_id = l_lineid;

426: )
427: IS
428:
429: CURSOR c_salesrep_info(l_lineid number) IS
430: SELECT salesrep_id from OE_ORDER_LINES_ALL WHERE line_id = l_lineid;
431:
432: CURSOR c_defaulthdrline_rec(c_ordhdr_typeid number) IS
433: select order_type_id from oe_order_headers_all where header_id = c_ordhdr_typeid;
434:

Line 437: from oe_order_lines_all

433: select order_type_id from oe_order_headers_all where header_id = c_ordhdr_typeid;
434:
435: CURSOR OrigOrderQtyCur(c_origqtyLineId number) IS
436: select ordered_quantity
437: from oe_order_lines_all
438: where line_id= c_origqtyLineId;
439:
440: l_tmp_origQty NUMBER;
441: l_salesrep_info_rec c_salesrep_info%rowtype;

Line 941: select invoice_to_org_id,ship_to_org_id from oe_order_lines_all where line_id = l_lineId;

937: )
938: IS
939:
940: cursor c_get_lineInfo(l_lineId Number) is
941: select invoice_to_org_id,ship_to_org_id from oe_order_lines_all where line_id = l_lineId;
942:
943: l_line_rec c_get_lineInfo%rowtype;
944:
945: cursor c_party_type(cpt_party_id NUMBER) is

Line 1369: l_linetmp_qry := 'select line_id from oe_order_lines_all '||

1365: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1366: IBE_Util.Debug('After calling Lead_Import package');
1367: END IF;
1368:
1369: l_linetmp_qry := 'select line_id from oe_order_lines_all '||
1370: 'where header_id= :1 and '||
1371: 'line_id NOT IN('|| l_all_lineids_query ||')';
1372:
1373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1428: from oe_order_lines_all

1424: IS
1425:
1426: cursor l_childlineid_cur(c_mdlop_lineid Number, c_modop_hdr_id number) is
1427: select line_id,ordered_quantity,line_category_code,header_id
1428: from oe_order_lines_all
1429: where ('ORDER',return_attribute1,return_attribute2) in
1430: (select line_category_code,header_id,line_id
1431: from oe_order_lines_all
1432: where ('RETURN',header_id, top_model_line_id) in

Line 1431: from oe_order_lines_all

1427: select line_id,ordered_quantity,line_category_code,header_id
1428: from oe_order_lines_all
1429: where ('ORDER',return_attribute1,return_attribute2) in
1430: (select line_category_code,header_id,line_id
1431: from oe_order_lines_all
1432: where ('RETURN',header_id, top_model_line_id) in
1433: (select line_category_code,return_attribute1,return_attribute2
1434: from oe_order_lines_all
1435: where line_id= c_mdlop_lineid)

Line 1434: from oe_order_lines_all

1430: (select line_category_code,header_id,line_id
1431: from oe_order_lines_all
1432: where ('RETURN',header_id, top_model_line_id) in
1433: (select line_category_code,return_attribute1,return_attribute2
1434: from oe_order_lines_all
1435: where line_id= c_mdlop_lineid)
1436: and link_to_line_id is not null)
1437: and header_id = c_modop_hdr_id;
1438:

Line 1442: select ordered_quantity from oe_order_lines_all

1438:
1439: -- last condn is added becos same item could have been returned twice in diffrt retns.
1440:
1441: cursor l_tmpparent_cur(l_mdlop_line_id number) is
1442: select ordered_quantity from oe_order_lines_all
1443: where line_id = l_mdlop_line_id;
1444:
1445: cursor c_linetmp_cur(c_linetmp_id number) is
1446: Select item_type_code from oe_order_lines_all where line_id =

Line 1446: Select item_type_code from oe_order_lines_all where line_id =

1442: select ordered_quantity from oe_order_lines_all
1443: where line_id = l_mdlop_line_id;
1444:
1445: cursor c_linetmp_cur(c_linetmp_id number) is
1446: Select item_type_code from oe_order_lines_all where line_id =
1447: (Select return_attribute2 from oe_order_lines_all where line_id = c_linetmp_id);
1448:
1449: l_tmpparent_rec l_tmpparent_cur%rowtype;
1450: l_childlineid_rec l_childlineid_cur%rowtype;

Line 1447: (Select return_attribute2 from oe_order_lines_all where line_id = c_linetmp_id);

1443: where line_id = l_mdlop_line_id;
1444:
1445: cursor c_linetmp_cur(c_linetmp_id number) is
1446: Select item_type_code from oe_order_lines_all where line_id =
1447: (Select return_attribute2 from oe_order_lines_all where line_id = c_linetmp_id);
1448:
1449: l_tmpparent_rec l_tmpparent_cur%rowtype;
1450: l_childlineid_rec l_childlineid_cur%rowtype;
1451: c_linetmp_rec c_linetmp_cur%rowtype;

Line 1688: FROM oe_order_lines_all

1684:
1685: CURSOR QtyChkLineCur(qtychk_hdrid NUMBER) IS
1686: SELECT Line_id,inventory_item_id,reference_line_id,ordered_quantity,
1687: line_number,return_attribute1,return_attribute2
1688: FROM oe_order_lines_all
1689: WHERE header_id=qtychk_hdrid
1690: ORDER BY line_number;
1691:
1692:

Line 1844: 'FROM oe_order_lines_all OEL,'||

1840: -- For MODEL items, the error messg. would be generic.
1841:
1842: l_qty_tmp_query := 'SELECT OEH.order_number,msi.concatenated_segments,msi.DESCRIPTION,'||
1843: 'OEL.line_id,OEL.item_type_code '||
1844: 'FROM oe_order_lines_all OEL,'||
1845: 'oe_order_headers_all OEH,'||
1846: 'mtl_system_items_vl msi '||
1847: 'WHERE OEL.header_id = OEH.header_id '||
1848: 'AND OEL.inventory_item_id = msi.inventory_item_Id '||

Line 1852: 'FROM oe_order_lines_all '||

1848: 'AND OEL.inventory_item_id = msi.inventory_item_Id '||
1849: 'AND msi.organization_id = oe_profile.value(''OE_ORGANIZATION_ID'', OEL.org_id) '||
1850: 'AND OEL.line_id IN('||
1851: 'SELECT nvl(top_model_line_id,line_id) '||
1852: 'FROM oe_order_lines_all '||
1853: 'WHERE line_id IN('||
1854: 'SELECT return_attribute2 '||
1855: 'FROM oe_order_lines_all '||
1856: 'WHERE line_id in('||l_tmp_error_lineIds||')))';

Line 1855: 'FROM oe_order_lines_all '||

1851: 'SELECT nvl(top_model_line_id,line_id) '||
1852: 'FROM oe_order_lines_all '||
1853: 'WHERE line_id IN('||
1854: 'SELECT return_attribute2 '||
1855: 'FROM oe_order_lines_all '||
1856: 'WHERE line_id in('||l_tmp_error_lineIds||')))';
1857:
1858:
1859: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2100: 'OE_ORDER_LINES_ALL LINES '||

2096: if (p_site_use_type ='BILL_TO') then
2097: l_addr_validate_qry:='SELECT LINES.LINE_ID '||
2098: 'FROM HZ_CUST_SITE_USES SITE, '||
2099: 'HZ_CUST_ACCT_SITES ACCT_SITE, '||
2100: 'OE_ORDER_LINES_ALL LINES '||
2101: 'WHERE LINES.HEADER_ID = :InvChkHdrId '||
2102: 'AND SITE.SITE_USE_ID = LINES.invoice_to_org_id '||
2103: 'AND SITE.SITE_USE_CODE = ''BILL_TO'' '||
2104: 'AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID '||

Line 2122: 'OE_ORDER_LINES_ALL LINES '||

2118:
2119: l_addr_validate_qry :='SELECT LINES.LINE_ID '||
2120: 'FROM HZ_CUST_SITE_USES SITE, '||
2121: 'HZ_CUST_ACCT_SITES ACCT_SITE, '||
2122: 'OE_ORDER_LINES_ALL LINES '||
2123: 'WHERE LINES.HEADER_ID = :shpChkHdrId '||
2124: 'AND SITE.SITE_USE_ID = LINES.ship_to_org_id '||
2125: 'AND SITE.SITE_USE_CODE = ''SHIP_TO'' '||
2126: 'AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID '||

Line 2275: 'FROM OE_ORDER_LINES_ALL LINES, '||

2271: end if;
2272:
2273: if (p_site_use_type ='BILL_TO') then
2274: l_contact_validate_qry:='SELECT LINES.LINE_ID '||
2275: 'FROM OE_ORDER_LINES_ALL LINES, '||
2276: 'HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, '||
2277: 'HZ_CUST_SITE_USES_ALL INV, '||
2278: 'HZ_CUST_ACCT_SITES_ALL ADDR '||
2279: 'WHERE LINES.HEADER_ID = :InvCntChkHdrId '||

Line 2291: 'FROM OE_ORDER_LINES_ALL LINES, '||

2287:
2288: elsif(p_site_use_type = 'SHIP_TO') then
2289:
2290: l_contact_validate_qry:='SELECT LINES.LINE_ID '||
2291: 'FROM OE_ORDER_LINES_ALL LINES, '||
2292: 'HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, '||
2293: 'HZ_CUST_SITE_USES_ALL INV, '||
2294: 'HZ_CUST_ACCT_SITES_ALL ADDR '||
2295: 'WHERE LINES.HEADER_ID = :InvCntChkHdrId '||

Line 3045: l_dl_tmp_qry := 'SELECT count(*) from oe_order_lines_all '||

3041: end loop;
3042:
3043: IBE_LEAD_IMPORT_PVT.parseInput (p_dl_line_ids, 'CHAR', l_parseKey, l_parseNum, l_dl_line_id_qry);
3044:
3045: l_dl_tmp_qry := 'SELECT count(*) from oe_order_lines_all '||
3046: 'WHERE header_id= :dl_header_id '||
3047: 'AND line_id NOT IN('||l_dl_line_id_qry||')';
3048:
3049: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3531: select * from oe_order_lines_all where line_id = l_lineId;

3527: l_api_name VARCHAR2(100) := 'Check Constraints';
3528: l_api_version NUMBER := 1.0;
3529:
3530: cursor c_get_lineInfo(l_lineId Number) is
3531: select * from oe_order_lines_all where line_id = l_lineId;
3532:
3533: l_line_rec OE_Order_PUB.Line_Rec_Type;
3534: l_line_type_id NUMBER;
3535: l_siteuse_id NUMBER;