APPS.IBE_REPORTING_PVT dependencies on FND_LOOKUPS

Line 55: From Fnd_Lookups

51: PRAGMA EXCEPTION_INIT(IBE_ECR_RATES_MISSING_ERR,-20205);
52:
53: Cursor c_lookup(ptype IN Varchar2) IS
54: Select LookUp_Code,Meaning
55: From Fnd_Lookups
56: Where Lookup_Type = ptype;
57:
58: Cursor c_currency(ptype IN Varchar2) IS
59: Select LookUp_Code

Line 60: From Fnd_Lookups

56: Where Lookup_Type = ptype;
57:
58: Cursor c_currency(ptype IN Varchar2) IS
59: Select LookUp_Code
60: From Fnd_Lookups
61: Where Lookup_Type = ptype;
62:
63:
64: PROCEDURE printDebugLog(pDebugStmt Varchar2) IS

Line 656: From fnd_lookups

652: printDebugLog(fnd_global.tab||'IN Parameters: None');
653: END IF;
654:
655: Select nvl(max(to_number(lookup_code)),20) into pRows
656: From fnd_lookups
657: Where lookup_type = l_type;
658:
659: IF (l_debug = 'Y') THEN
660: printDebugLog(fnd_global.tab||'OUT Parameters: '||to_char(pRows));

Line 810: fnd_lookups fndlkp

806: trunc(oh.ordered_date) ordered_date
807: FROM
808: Oe_order_Sources OS,
809: oe_order_headers_all oh,
810: fnd_lookups fndlkp
811: WHERE
812: nvl(oh.booked_flag,'N') = 'Y'
813: AND nvl(oh.cancelled_flag,'N') = 'N'
814: AND fndlkp.lookup_type = 'IBE_ECR_ORDER_SOURCE'

Line 824: fnd_lookups fndlkp

820: a.currency_code Transactional_Curr_Code,
821: to_date(pToDate,'yyyy/mm/dd hh24:mi:ss') ordered_date
822: FROM
823: aso_quote_headers_all a,
824: fnd_lookups fndlkp
825: WHERE
826: a.quote_header_id = (SELECT max(quote_header_id) quote_header_id
827: FROM aso_quote_headers_all
828: WHERE quote_number = a.quote_number)

Line 946: fnd_lookups fndlkp

942: Oe_order_lines_all OL,
943: hz_cust_accounts hca,
944: hz_cust_site_uses_all hcsu,
945: hz_cust_acct_sites_all hcas,
946: fnd_lookups fndlkp
947: WHERE fndlkp.lookup_type = l_fact_source
948: AND fndlkp.lookup_code = upper(OS.Name)
949: AND OH.Source_Document_Type_ID = OS.order_source_id
950: AND OH.Header_id = OL.Header_id

Line 1068: Fnd_lookups fndlkp

1064: Sum(decode(nvl(OH.Booked_Flag,'N'),'N',0, nvl(QL.Quantity,0))) AS Order_Quantity
1065: FROM Aso_quote_headers_all QH,
1066: Aso_quote_lines_all QL,
1067: OE_Order_Headers_ALL OH,
1068: Fnd_lookups fndlkp
1069: WHERE fndlkp.lookup_type = l_fact_source
1070: AND upper(Qh.Quote_Source_Code) = fndlkp.lookup_code
1071: AND QH.Creation_Date between pFromDate and pToDate
1072: AND Qh.quote_header_id = Ql.quote_header_id