Analytics Software

Hello,

I am using the following query in BIP.

+ select wdd.currency_code currency_code,
wdd.inventory_item_id line_item,
wdd.date_requested,
nvl(wdd.source_line_set_id,wdd.source_line_id) source_line_set_id,
decode( :p_sort_by,
'CUSTOMER',
substrb(party.party_name,1,50),
'WAREHOUSE',
ood.organization_name,
'ORDER',
wdd.source_header_number,
null) sort_by,
wdd.source_header_number order_number,
wdd.source_header_id source_header_id, substrb(party.party_name,1,50) customer_name,
cust_acct.account_number customer_number,
wdd.source_line_id,
wdd.src_requested_quantity ordered_qty,
wdd.src_requested_quantity_uom order_UOM,
wdd.source_line_number line_number,
wdd.top_model_line_id option_number,
&rp_item_flex_all_seg item_code,
wdd.inventory_item_id,
wdd.item_description,
wdd.source_code,
wdd.shipment_priority_code,
wdd.requested_quantity_uom,
sum(nvl(wdd.requested_quantity,0)) backordered_quantity,
wdd.date_scheduled,
wdd.organization_id,
ood.organization_name,
WSHRDBDR.cf_curr_oamt_dspformula(wdd.currency_code) CF_CURR_OAMT_DSP,
WSHRDBDR.cf_curr_bamt_dspformula(wdd.currency_code) CF_CURR_BAMT_DSP,
WSHRDBDR.cf_curr_enabledformula(:CS_COUNT_SORT_ENABLED, :CS_SUM_SORT_ENABLED) CF_CURR_ENABLED,
WSHRDBDR.cf_sort_oamt_dspformula(wdd.currency_code) CF_SORT_OAMT_DSP,
WSHRDBDR.cf_sort_bamt_dspformula(wdd.currency_code) CF_SORT_BAMT_DSP,
WSHRDBDR.cf_sort_enabledformula(:CS_COUNT_DUOM, :CS_SUM_DUOM) CF_SORT_ENABLED,
WSHRDBDR.cf_ord_oamt_dspformula(wdd.currency_code) CF_ORD_OAMT_DSP,
WSHRDBDR.cf_ord_bamt_dspformula(wdd.currency_code) CF_ORD_BAMT_DSP,
WSHRDBDR.cf_distinct_uomformula(wdd.source_header_number) CF_DISTINCT_UOM,
WSHRDBDR.cf_source_codeformula(wdd.source_code) CF_source_code,
WSHRDBDR.cf_line_ord_amt_dspformula(wdd.currency_code) CF_LINE_ORD_AMT_DSP,
WSHRDBDR.cf_line_ordered_amtformula(:CF_LINE_ORDERED_QTY, :CF_selling_price) CF_LINE_ORDERED_AMT,
WSHRDBDR.cf_line_ordered_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id )) CF_LINE_ORDERED_QTY,
WSHRDBDR.cf_line_shipped_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id) CF_LINE_SHIPPED_QTY,
WSHRDBDR.cf_line_item_displayformula(wdd.inventory_item_id, wdd.organization_id, wdd.item_description) CF_LINE_ITEM_DISPLAY,
WSHRDBDR.cf_line_bo_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id) CF_LINE_BO_QTY,
WSHRDBDR.cf_line_bo_amt_dspformula(wdd.currency_code) CF_LINE_BO_AMT_DSP,
WSHRDBDR.cf_line_bo_amtformula(WSHRDBDR.cf_line_bo_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id) , :CF_selling_price) CF_LINE_BO_AMT,
WSHRDBDR.cf_days_lateformula(:CF_promise_date) CF_days_late,
WSHRDBDR.cf_promise_dateformula(wdd.source_line_id) CF_promise_date,
WSHRDBDR.cf_item_displayformula(wdd.inventory_item_id, wdd.organization_id, wdd.item_description) CF_ITEM_DISPLAY,
WSHRDBDR.cf_selling_priceformula(wdd.source_line_id) CF_selling_price
from org_organization_definitions ood,
hz_parties party,
hz_cust_accounts cust_acct,
&lp_item_from
&lp_country_from
wsh_delivery_details wdd,
mtl_system_items_vl si where wdd.inventory_item_id = si.inventory_item_id (+) and wdd.organization_id = si.organization_id
and wdd.released_status = 'B'
and wdd.replenishment_status is null and cust_acct.party_id = party.party_id
and wdd.customer_id = cust_acct.cust_account_id
and wdd.organization_id = ood.organization_id
and wdd.source_code = :P_SOURCE_SYSTEM
&lp_item_id
&lp_item_where
&lp_inventory
&lp_header_number
&lp_order_type
&lp_customer
&lp_warehouse
&lp_created_by
&lp_country_where
&lp_source_code
group by
wdd.currency_code,
wdd.inventory_item_id,
wdd.date_requested,
substrb(party.party_name,1,50),
ood.organization_name,
wdd.source_header_number,
wdd.source_header_id, cust_acct.account_number,
wdd.source_line_id,
wdd.src_requested_quantity,
wdd.src_requested_quantity_uom,
wdd.source_line_number,
wdd.top_model_line_id,
wdd.inventory_item_id,
wdd.item_description,
wdd.source_code,
wdd.shipment_priority_code,
wdd.requested_quantity_uom,
wdd.date_scheduled,
wdd.organization_id,
wdd.source_line_set_id,
&rp_item_flex_all_seg
order by
wdd.currency_code,
decode( :p_sort_by,
'CUSTOMER',
substrb(party.party_name,1,50),
'WAREHOUSE',
ood.organization_name,
'ORDER',
wdd.source_header_number,
null)
+

After providing this query and when i click OK, the parameters screen pops up, but the name of the parameters are seen as:
*&rp_item_flex_all_seg item_code, wdd.inventory_item_id, wdd.item_description, wdd.source_code, wdd.shipment_priority_code, wdd.requested_quantity_uom, sum

*&lp_item_from &lp_country_from wsh_delivery_details wdd, mtl_system_items_vl si where wdd.inventory_item_id


The params are not getting properly delimited and it always ends up in the error 'Table does not exist.'

Can someone please help me with this?

UPDATE: All lexical params used in the query are properly defined under the parameters section.

Edited by: obiee_newbie on Jan 10, 2012 2:51 AM