Tuesday, August 23, 2016

Join Relations Between tables in O2C

1------------HEADER_ID------------
select * from oe_order_headers_all;
select * from oe_order_lines_all;

2---------CUSTOMER_ID-----SOLD_TO_ORG_ID-----
select * from RA_CUSTOMERS;
SELECT * FROM OE_ORDER_HEADERS_ALL;

3------CUSTOMER_ID---SOLD_TO_ORG_ID------------------
select * from RA_CUSTOMERS;
select * from oe_order_lines_all;


4------------wdd.delivery_detail_id----wdt.delivery_detail_id----
SELECT * FROM WSH_DELIVERY_DETAILS;
SELECT * FROM WSH_DELIVERY_TRIPS_V;

5------CUSTOMER_ID-----------CUSTOMER_ID-----------

SELECT * FROM WSH_DELIVERY_DETAILS;
select * from RA_CUSTOMERS;

6-------------CUST_PO_NUMBER----------CUST_PO_NUMBER----------
SELECT * FROM oe_order_headers_all;
SELECT * FROM WSH_DELIVERY_DETAILS ;

7-------------CUST_PO_NUMBER----------CUST_PO_NUMBER----------
SELECT * FROM WSH_DELIVERY_DETAILS ;
select * from oe_order_lines_all;



8--------D.SEGMENT1||'.'||D.SEGMENT2=L.ORDERED_ITEM----------
select * from oe_order_lines_all D;
SELECT * FROM mtl_system_items_b L;
--Join oe_order_lines_all and oe_order_headers_all using ---HEADER_ID----

9------------D.SOLD_TO_CUSTOMER_ID=L.customer_id----------
select * from ra_customer_trx_all D;
select * from RA_CUSTOMERS L;

10-----------D.LIST_HEADER_ID=L.LIST_HEADER_ID-------------
SELECT * FROM QP_LIST_HEADERS_V D;
SELECT * FROM QP_LIST_LINES_V L;

11.-----------L.LIST_HEADER_ID=D.LIST_HEADER_ID---------------
SELECT * FROM qp_pricing_attributes L;
SELECT * FROM QP_LIST_HEADERS_V D;

12-------------D.LIST_LINE_ID=L.LIST_LINE_ID---------------
SELECT * FROM qp_pricing_attributes L;
SELECT * FROM QP_LIST_LINES_V D;

No comments:

Post a Comment