order to cash cycle in oracle apps
select * from oe_order_headers_all where order_number=66161;
select * from oe_order_lines_all where header_id =
(select header_id from oe_order_headers_all where order_number=66161);
select * from WSH_DELIVERY_DETAILS where source_header_id =
(select header_id from oe_order_headers_all where order_number=66161);
select * from WSH_DELIVERY_ASSIGNMENTS where DELIVERY_DETAIL_ID in (
select DELIVERY_DETAIL_ID from WSH_DELIVERY_DETAILS wheresource_header_id =
(select header_id from oe_order_headers_all where order_number=66161));
select * from wsh_new_deliveries where delivery_id in
(select delivery_id from WSH_DELIVERY_ASSIGNMENTS whereDELIVERY_DETAIL_ID in (
select DELIVERY_DETAIL_ID from WSH_DELIVERY_DETAILS wheresource_header_id =
(select header_id from oe_order_headers_all whereorder_number=66161)));
select * from ra_customer_trx_all where (INTERFACE_HEADER_ATTRIBUTE1)=(
select to_char(order_number) from oe_order_headers_all where header_id=(select header_id
from oe_order_headers_all where order_number=66162));
select * from ra_customer_trx_lines_all where(INTERFACE_line_ATTRIBUTE1)=(
select to_char(order_number) from oe_order_headers_all where header_id=(select header_id
from oe_order_headers_all where order_number=66162));
select * from ra_customer_trx_lines_all where(INTERFACE_line_ATTRIBUTE3) in
(select to_char(delivery_id) from WSH_DELIVERY_ASSIGNMENTS whereDELIVERY_DETAIL_ID in (
select DELIVERY_DETAIL_ID from WSH_DELIVERY_DETAILS wheresource_header_id =
(select header_id from oe_order_headers_all where order_number=66161)))
select * from ar_cash_receipts_all where cash_receipt_id =(
select cash_receipt_id from ap_payment_schedules_All
(select distinct customer_trx_id from ra_customer_trx_all where(INTERFACE_HEADER_ATTRIBUTE1)=(
select to_char(order_number) from oe_order_headers_all where header_id=(select header_id
from oe_order_headers_all where order_number=66162));
select * from AR_RECEIVABLE_APPLICATIONS_ALL where CUSTOMER_TRX_ID =
(select CUSTOMER_TRX_ID from ra_customer_trx_all where(INTERFACE_HEADER_ATTRIBUTE1)=(
select to_char(order_number) from oe_order_headers_all where header_id=(select header_id
from oe_order_headers_all where order_number=66162)));
select * from ar_cash_receipts_all where cash_receipt_id = (
select cash_receipt_id from AR_RECEIVABLE_APPLICATIONS_ALL whereCUSTOMER_TRX_ID =
(select CUSTOMER_TRX_ID from ra_customer_trx_all where(INTERFACE_HEADER_ATTRIBUTE1)=(
select to_char(order_number) from oe_order_headers_all where header_id=(select header_id
from oe_order_headers_all where order_number=66162))));
select * from gl_code_combinations where code_combination_id = (
select code_combination_id from AR_RECEIVABLE_APPLICATIONS_ALL whereCUSTOMER_TRX_ID =
(select CUSTOMER_TRX_ID from ra_customer_trx_all where(INTERFACE_HEADER_ATTRIBUTE1)=(
select to_char(order_number) from oe_order_headers_all where header_id=(select header_id
from oe_order_headers_all where order_number=66162))));
procure to pay cycle in oracle apps
select * from po_requisition_headers_all where segment1='14319';
select * from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319');
select * from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'));
select * from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')));
select * from po_headers_all
where po_header_id= (select po_header_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'))));
select * from po_lines_all
where po_line_id =( select po_line_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'))));
select * from po_line_locations_all
where line_location_id=(select line_location_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'))));
select * from rcv_transactions
where shipment_header_id=(select po_header_id from po_headers_all
where po_header_id= (select po_header_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')))));
select * from rcv_shipment_headers
where shipment_header_id=(select po_header_id from po_headers_all
where po_header_id= (select po_header_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')))));
select * from rcv_shipment_lines
where shipment_header_id=(select po_header_id from po_headers_all
where po_header_id= (select po_header_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')))));
select * from ap_invoice_distributions_all
where po_distribution_id =(select po_distribution_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'))));
select * from ap_invoices_all
where invoice_id = (select invoice_id from ap_invoice_distributions_all
where po_distribution_id =(select po_distribution_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')))));
select * from ap_invoice_payments_all
where invoice_id = (select invoice_id from ap_invoice_distributions_all
where po_distribution_id =(select po_distribution_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')))));
select * from ap_checks_all
where check_id=(select check_id from ap_invoice_payments_all
where invoice_id = (select invoice_id from ap_invoice_distributions_all
where po_distribution_id =(select po_distribution_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'))))));
select * from gl_code_combinations
where code_combination_id =(select dist_code_combination_id from ap_invoice_distributions_all
where po_distribution_id =(select po_distribution_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319')))));
select * from gl_ledgers
where chart_of_accounts_id=(select chart_of_accounts_id from gl_code_combinations
where code_combination_id =(select dist_code_combination_id from ap_invoice_distributions_all
where po_distribution_id =(select po_distribution_id from po_distributions_all
where po_distribution_id=(select distribution_id from po_req_distributions_all
where requisition_line_id =(select requisition_line_id from po_requisition_lines_all
where requisition_header_id =(select requisition_header_id
from po_requisition_headers_all
where segment1='14319'))))));
No comments:
Post a Comment