AP发票凭证表：
SELECT AIA.INVOICE_NUM,
AIA.INVOICE_DATE,
AIA.CREATION_DATE,
AIA.VENDOR_ID,
AIA.INVOICE_CURRENCY_CODE,
AIL.AMOUNT,
AIL.BASE_AMOUNT,
AIA.DESCRIPTION, DECODE(AIL.BASE_AMOUNT,NULL,1,ROUND(AIL.BASE_AMOUNT/AIL.AMOUNT,4)),
AIL.INVENTORY_ITEM_ID,
AIL.QUANTITY_INVOICED,
AIL.UNIT_PRICE,
AIL.AMOUNT,
AIL.BASE_AMOUNT,
AIL.RCV_TRANSACTION_ID,
MSI.SEGMENT1,
MSI.DESCRIPTION,
RSH.RECEIPT_NUM,
PHA.SEGMENT1,
PV.VENDOR_NAME,
RSL.QUANTITY_RECEIVED
FROM AP.AP_INVOICES_ALL AIA,
AP.AP_INVOICE_LINES_ALL AIL,
PO.PO_HEADERS_ALL PHA,
APPS.PO_VENDORS PV,
INV.MTL_SYSTEM_ITEMS_B MSI,
RCV_SHIPMENT_HEADERS RSH, --接收头
RCV_SHIPMENT_LINES RSL --接收行
SELECT AIA.INVOICE_NUM,
AIA.INVOICE_DATE,
AIA.CREATION_DATE,
AIA.VENDOR_ID,
AIA.INVOICE_CURRENCY_CODE,
AIL.AMOUNT,
AIL.BASE_AMOUNT,
AIA.DESCRIPTION, DECODE(AIL.BASE_AMOUNT,NULL,1,ROUND(AIL.BASE_AMOUNT/AIL.AMOUNT,4)),
AIL.INVENTORY_ITEM_ID,
AIL.QUANTITY_INVOICED,
AIL.UNIT_PRICE,
AIL.AMOUNT,
AIL.BASE_AMOUNT,
AIL.RCV_TRANSACTION_ID,
MSI.SEGMENT1,
MSI.DESCRIPTION,
RSH.RECEIPT_NUM,
PHA.SEGMENT1,
PV.VENDOR_NAME,
RSL.QUANTITY_RECEIVED
FROM AP.AP_INVOICES_ALL AIA,
AP.AP_INVOICE_LINES_ALL AIL,
PO.PO_HEADERS_ALL PHA,
APPS.PO_VENDORS PV,
INV.MTL_SYSTEM_ITEMS_B MSI,
RCV_SHIPMENT_HEADERS RSH, --接收头
RCV_SHIPMENT_LINES RSL --接收行
WHERE AIA.INVOICE_ID = AIL.INVOICE_ID
AND AIL.PO_HEADER_ID = PHA.PO_HEADER_ID(+)
AND AIA.VENDOR_ID = PV.VENDOR_ID
AND AIL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND AIL.ORG_ID = MSI.ORGANIZATION_ID(+)
AND AIL.RCV_SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID(+)
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID(+)
AND AIL.LINE_TYPE_LOOKUP_CODE = 'ITEM'
AND AIL.PO_HEADER_ID = PHA.PO_HEADER_ID(+)
AND AIA.VENDOR_ID = PV.VENDOR_ID
AND AIL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND AIL.ORG_ID = MSI.ORGANIZATION_ID(+)
AND AIL.RCV_SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID(+)
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID(+)
AND AIL.LINE_TYPE_LOOKUP_CODE = 'ITEM'
财务各表释义：
GL_JE_BATCHES_HEADERS_V --
GL_JE_LINES --
GL_IMPORT_REFERENCES --
XLA_AE_LINES --
XLA_AE_HEADERS --
AP_SUPPLIERS --
HZ_PARTIES --
HZ_CUST_ACCOUNTS --
XLA_TRANSACTION_ENTITIES --
GL_SETS_OF_BOOKS --
GL_PERIODS --
FND_USER --
GL_LOOKUPS --
GL_CODE_COMBINATIONS --
XLA_DISTRIBUTION_LINKS --
RA_CUST_TRX_LINE_GL_DIST_ALL --
RA_CUSTOMER_TRX_LINES_ALL --
RA_CUSTOMER_TRX_ALL --
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26101098/viewspace-714225/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
