Retrieving Sales Order Line ID, PO Line ID, and PO Distribution ID for Back-to-Back Sales Orders
Summary:
I need to retrieve the Sales Order Line ID, PO Line ID, and PO Distribution ID from XLA_ae_lines for back-to-back sales orders in Oracle Fusion.
cst_transactions displays data that is not according to my customers business case.
Content (please ensure you mask any confidential information):
I am working on a back-to-back sales order report and need to retrieve the following information:
- Sales Order Line ID
- PO Line ID
- PO Distribution ID
I am currently using the following query to extract the XLA_ae_lines:
sqlCopy codeselect xal.* from xla_ae_lines xal where xal.ACCOUNTING_CLASS_CODE = 'COST_OF_GOODS_SOLD'
0