[Home] [Help]
View: JAI_AP_ST_MATCH_DTL_GRPRCPT_V
View Text
SELECT B.ST_HDR_ID
, A.FORM_TYPE
, D.FORM_ID
, B.INVOICE_ID
, B.ISSUE_RECEIPT_FLAG
, B.ORDER_FLAG
, B.ORDER_NUMBER
, B.TRX_TYPE_ID
, B.TRX_NUMBER
, SUM(NVL(B.TAX_TARGET_AMOUNT
, 0)) INV_TAX_TARGET_AMT
, SUM(E.MATCHED_AMOUNT) INV_MATCHED_AMOUNT FROM JAI_CMN_STFORM_HDRS_ALL A
, JAI_CMN_ST_FORM_DTLS B
, JAI_CMN_TAXES_ALL C
, JAI_CMN_ST_FORMS D
, JAI_CMN_ST_MATCH_DTLS E
WHERE A.ST_HDR_ID = B.ST_HDR_ID AND B.TAX_ID = C.TAX_ID AND A.FORM_TYPE = C.STFORM_TYPE AND A.PARTY_TYPE_FLAG = 'C' AND B.ISSUE_RECEIPT_FLAG = 'R' AND A.ST_HDR_ID = D.ST_HDR_ID AND D.ST_HDR_ID = E.ST_HDR_ID AND D.FORM_ID = E.FORM_ID AND B.ST_DTL_ID = E.ST_DTL_ID GROUP BY B.ST_HDR_ID
, A.FORM_TYPE
, D.FORM_ID
, B.INVOICE_ID
, B.ISSUE_RECEIPT_FLAG
, B.ORDER_FLAG
, B.ORDER_NUMBER
, B.TRX_TYPE_ID
, B.TRX_NUMBER
Columns
Name |
ST_HDR_ID |
FORM_TYPE |
FORM_ID |
INVOICE_ID |
ISSUE_RECEIPT_FLAG |
ORDER_FLAG |
ORDER_NUMBER |
TRX_TYPE_ID |
TRX_NUMBER |
INV_TAX_TARGET_AMT |
INV_MATCHED_AMOUNT |