View: JAI_AP_ST_FORMS_DTL_GRPRCPT_V

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

View Text

SELECT B.ST_HDR_ID
, A.FORM_TYPE
, 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(NVL(B.MATCHED_AMOUNT
, 0)) INV_MATCHED_AMT
FROM JAI_CMN_STFORM_HDRS_ALL A
, JAI_CMN_ST_FORM_DTLS B
, JAI_CMN_TAXES_ALL C
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' GROUP BY B.ST_HDR_ID
, A.FORM_TYPE
, B.INVOICE_ID
, B.ISSUE_RECEIPT_FLAG
, B.ORDER_FLAG
, B.ORDER_NUMBER
, B.TRX_TYPE_ID
, B.TRX_NUMBER

Columns