Home » Applications » Oracle Fusion Apps & E-Business Suite » apps table joins
apps table joins [message #318074] Mon, 05 May 2008 09:09 Go to next message
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

Re: apps table joins [message #319198 is a reply to message #318074] Fri, 09 May 2008 05:36 Go to previous message
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
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:
  


Current Time: Sun Dec 04 13:02:07 CST 2016

Total time taken to generate the page: 0.08390 seconds