VIEW: APPS.JAI_AP_ST_MATCH_DTL_GRPRCPT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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