VIEW: APPS.INL_CORR_MATCHES_V

Source

View Text - Preformatted

SELECT mat1.match_id, mat1.match_type_code, mat1.ship_header_id, mat1.from_parent_table_name, mat1.from_parent_table_id, mat1.to_parent_table_name, mat1.to_parent_table_id, mat1.matched_qty, mat1.matched_uom_code, NVL(DECODE(mat1.matched_curr_code, mat2.matched_curr_code, mat2.matched_amt, inl_landedcost_pvt.Converted_Amt(mat2.matched_amt, mat2.matched_curr_code, mat1.matched_curr_code, mat1.matched_curr_conversion_type, mat1.matched_curr_conversion_date)), mat1.matched_amt) AS matched_amt, DECODE(mat2.match_id, mat1.match_id, NULL, mat2.match_id) AS correction_match_id, mat1.matched_curr_code, mat1.matched_curr_conversion_type, mat1.matched_curr_conversion_date, mat1.matched_curr_conversion_rate, NVL(mat2.adj_already_generated_flag,mat1.adj_already_generated_flag) AS adj_already_generated_flag, mat1.replace_estim_qty_flag, NVL(mat2.existing_match_info_flag, mat1.existing_match_info_flag) AS existing_match_info_flag, mat1.charge_line_type_id, mat1.party_id, mat1.party_site_id, mat1.tax_code, mat1.nrec_tax_amt, mat1.tax_amt_included_flag, mat1.match_amount_id, mat1.program_id, mat1.program_update_date, mat1.program_application_id, mat1.request_id, mat1.created_by, mat1.creation_date, mat1.last_updated_by, mat1.last_update_date, mat1.last_update_login FROM inl_matches mat1, inl_matches mat2 WHERE mat2.parent_match_id (+) = mat1.match_id AND mat2.match_type_code (+) = 'CORRECTION' ORDER BY mat1.match_id

View Text - HTML Formatted

SELECT MAT1.MATCH_ID
, MAT1.MATCH_TYPE_CODE
, MAT1.SHIP_HEADER_ID
, MAT1.FROM_PARENT_TABLE_NAME
, MAT1.FROM_PARENT_TABLE_ID
, MAT1.TO_PARENT_TABLE_NAME
, MAT1.TO_PARENT_TABLE_ID
, MAT1.MATCHED_QTY
, MAT1.MATCHED_UOM_CODE
, NVL(DECODE(MAT1.MATCHED_CURR_CODE
, MAT2.MATCHED_CURR_CODE
, MAT2.MATCHED_AMT
, INL_LANDEDCOST_PVT.CONVERTED_AMT(MAT2.MATCHED_AMT
, MAT2.MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CONVERSION_TYPE
, MAT1.MATCHED_CURR_CONVERSION_DATE))
, MAT1.MATCHED_AMT) AS MATCHED_AMT
, DECODE(MAT2.MATCH_ID
, MAT1.MATCH_ID
, NULL
, MAT2.MATCH_ID) AS CORRECTION_MATCH_ID
, MAT1.MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CONVERSION_TYPE
, MAT1.MATCHED_CURR_CONVERSION_DATE
, MAT1.MATCHED_CURR_CONVERSION_RATE
, NVL(MAT2.ADJ_ALREADY_GENERATED_FLAG
, MAT1.ADJ_ALREADY_GENERATED_FLAG) AS ADJ_ALREADY_GENERATED_FLAG
, MAT1.REPLACE_ESTIM_QTY_FLAG
, NVL(MAT2.EXISTING_MATCH_INFO_FLAG
, MAT1.EXISTING_MATCH_INFO_FLAG) AS EXISTING_MATCH_INFO_FLAG
, MAT1.CHARGE_LINE_TYPE_ID
, MAT1.PARTY_ID
, MAT1.PARTY_SITE_ID
, MAT1.TAX_CODE
, MAT1.NREC_TAX_AMT
, MAT1.TAX_AMT_INCLUDED_FLAG
, MAT1.MATCH_AMOUNT_ID
, MAT1.PROGRAM_ID
, MAT1.PROGRAM_UPDATE_DATE
, MAT1.PROGRAM_APPLICATION_ID
, MAT1.REQUEST_ID
, MAT1.CREATED_BY
, MAT1.CREATION_DATE
, MAT1.LAST_UPDATED_BY
, MAT1.LAST_UPDATE_DATE
, MAT1.LAST_UPDATE_LOGIN
FROM INL_MATCHES MAT1
, INL_MATCHES MAT2
WHERE MAT2.PARENT_MATCH_ID (+) = MAT1.MATCH_ID
AND MAT2.MATCH_TYPE_CODE (+) = 'CORRECTION' ORDER BY MAT1.MATCH_ID