View: JAI_AR_ST_MATCH_DTL_GRPISS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AR_ST_MATCH_DTL_GRPISS_V

View Text

SELECT B.ST_HDR_ID
, B.HEADER_ID
, /* ADDED FOR FP BUG# 5636961 */ DECODE(A.PARTY_TYPE_FLAG
, 'V'
, NULL
, 'O'
, B.RCV_TRANSACTION_ID) RCV_TRANSACTION_ID
, /* ADDED FOR FP BUG# 5636961 */ A.FORM_TYPE
, D.FORM_ID
, B.INVOICE_ID
, B.ISSUE_RECEIPT_FLAG
, B.PO_NUM
, B.DOC_TYPE
, 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 IN ( 'V'
, 'O')
AND B.ISSUE_RECEIPT_FLAG = 'I' 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
, B.HEADER_ID
, /* ADDED FOR FP BUG# 5636961 */ DECODE(A.PARTY_TYPE_FLAG
, 'V'
, NULL
, 'O'
, B.RCV_TRANSACTION_ID)
, /* ADDED FOR FP BUG# 5636961 */ A.FORM_TYPE
, D.FORM_ID
, B.INVOICE_ID
, B.ISSUE_RECEIPT_FLAG
, B.PO_NUM
, B.DOC_TYPE

Columns