Query to find shipset and fulfilment set
Oracle apps shipset and fulfillment set query
SELECT order_number,
ship_set_id,
set_id fullfillment_set_id,
COUNT (DISTINCT PAYMENT_TERM_ID)
FROM (SELECT ship_set_id,
order_number,
line_number,
ool.payment_term_id,
set_id
FROM oe_order_headers_all ooh,
oe_order_lines_all ool,
(SELECT s.set_id,
s.set_name,
set_status,
s.header_id,
(SELECT open_flag
FROM oe_order_lines_all lin
WHERE lin.line_id = ls.line_id)
line_open,
ls.line_id
FROM oe_sets s, oe_line_sets ls, oe_order_headers_all oh
WHERE s.set_id = ls.set_id
AND s.set_type = 'FULFILLMENT_SET'
AND s.header_id = oh.header_id) fullfillment_set
WHERE ooh.header_id = ool.header_id
AND ooh.org_id = 1234 -- and order_number=92000065
AND fullfillment_set.line_id = ool.line_id)
GROUP BY order_number, ship_set_id, set_id
HAVING COUNT (DISTINCT PAYMENT_TERM_ID) > 1
Related posts:
- How to Retrieve Period to Date (PTD) and Year to Date (YTD) Balances of GL Account in Oracle R12
- Sales order line status query in Oracle apps
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to get price list details in Oracle EBS
- Query to find all APIs of Oracle Apps modules
- Oracle R12 shipping status query
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Query to get Sales order and lines details in Oracle Apps
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find serial number material transactions details
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set