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;
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