OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » apps table joins

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

apps table joins [message #318074]

Mon, 05 May 2008 09:09

amritaseema
Messages: 47
Registered: January 2008

Member

can any one please check my joins and tell me where i am wrong..
actually while i am trying to create table using this select statement its showing error "unable to extend temp segment by128 in tablespace TEMP"
so please anyone help me out,i think the joins may be wrong...
thanks in advance.

Thanks
Seema

select rct.customer_trx_id,
rctl.customer_trx_line_id,
rctl.quantity_ordered,
rctl.quantity_credited,
rctl.quantity_invoiced,
rctl.unit_selling_price,
rctl.extended_amount,
ooh.header_id,
ool.line_id,
msib.ORGANIZATION_ID,
otl.transaction_type_id,
msib.inventory_item_id,
mcb.category_id,
mcs.category_set_id,
hca.cust_account_id,
hp.party_id
from oe_order_headers_all_dim ooh,
oe_line_dim ool,
oe_transaction_types_tl_dim otl,
mtl_item_categories mic,
mtl_category_sets_b_dim mcs,
mtl_categories_b_dim mcb,
mtl_system_items_b_dim msib,
hz_parti_dim hp,
hz_cust_accounts_dim hca,
ra_customer_trx_lines_dim rctl,
ra_customer_trx_dim rct
where ooh.header_id=ool.header_id
and ooh.order_type_id = otl.transaction_type_id
and ool.ship_from_org_id=msib.organization_id
and ool.inventory_item_id=msib.inventory_item_id
and ool.ship_from_org_id=mic.organization_id
and ool.inventory_item_id=mic.inventory_item_id
and mcb.category_id=mic.category_id
and mcs.category_set_id=mic.category_set_id
and hca.cust_account_id=ooh.sold_to_org_id
and hca.party_id=hp.party_id
and rctl.inventory_item_id = msib.inventory_item_id
and rct.customer_trx_id=rctl.customer_trx_id
and rctl.inventory_item_id=ool.inventory_item_id

Report message to a moderator

Re: apps table joins [message #319198 is a reply to message #318074]

Fri, 09 May 2008 05:36

dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot

Junior Member

Pls use this quary I have corrected the table names...

SELECT rct.customer_trx_id,
rctl.customer_trx_line_id,
rctl.quantity_ordered,
rctl.quantity_credited,
rctl.quantity_invoiced,
rctl.unit_selling_price,
rctl.extended_amount,
ooh.header_id,
ool.line_id,
msib.ORGANIZATION_ID,
otl.transaction_type_id,
msib.inventory_item_id,
mcb.category_id,
mcs.category_set_id,
hca.cust_account_id,
hp.party_id
FROM oe_order_headers_all ooh,
oe_order_lines_all ool,
oe_transaction_types_tl otl,
mtl_item_categories mic,
mtl_category_sets_b mcs,
mtl_categories_b mcb,
mtl_system_items_b msib,
hz_parties hp,
hz_cust_accounts hca,
ra_customer_trx_lines rctl,
ra_customer_trx rct
WHERE ooh.header_id=ool.header_id
AND ooh.order_type_id = otl.transaction_type_id
AND ool.ship_from_org_id=msib.organization_id
AND ool.inventory_item_id=msib.inventory_item_id
AND ool.ship_from_org_id=mic.organization_id
AND ool.inventory_item_id=mic.inventory_item_id
AND mcb.category_id=mic.category_id
AND mcs.category_set_id=mic.category_set_id
AND hca.cust_account_id=ooh.sold_to_org_id
AND hca.party_id=hp.party_id
AND rctl.inventory_item_id = msib.inventory_item_id
AND rct.customer_trx_id=rctl.customer_trx_id
AND rctl.inventory_item_id=ool.inventory_item_id

Report message to a moderator

Previous Topic:	Customer Interface - How to set status of Site_use_code?
Next Topic:	Create accounitng process inAP is creating accounting for disabled values also

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 23:50:24 CDT 2024