VIEW: APPS.INL_CORR_MATCHES_V

Source

View Text - Preformatted

SELECT mat1.match_id, NVL(mat2.adj_group_date, mat1.adj_group_date) adj_group_date, mat1.match_type_code match_type_code, mat1.ship_header_id ship_header_id, mat1.from_parent_table_name from_parent_table_name , mat1.from_parent_table_id from_parent_table_id , mat1.to_parent_table_name to_parent_table_name , mat1.to_parent_table_id to_parent_table_id , mat1.matched_qty matched_qty , mat1.matched_uom_code 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) matched_amt, DECODE(mat2.match_id, mat1.match_id, NULL, mat2.match_id) correction_match_id, mat1.matched_curr_code matched_curr_code , mat1.matched_curr_conversion_type matched_curr_conversion_type , mat1.matched_curr_conversion_date matched_curr_conversion_date , mat1.matched_curr_conversion_rate matched_curr_conversion_rate , NVL(mat2.adj_already_generated_flag, mat1.adj_already_generated_flag) adj_already_generated_flag, mat1.replace_estim_qty_flag replace_estim_qty_flag, NVL(mat2.existing_match_info_flag, mat1.existing_match_info_flag) existing_match_info_flag, mat1.charge_line_type_id charge_line_type_id , mat1.party_id party_id , mat1.party_site_id party_site_id , mat1.tax_code tax_code , mat1.nrec_tax_amt nrec_tax_amt , mat1.tax_amt_included_flag tax_amt_included_flag , mat1.match_amount_id match_amount_id , mat1.program_id program_id , mat1.program_update_date program_update_date , mat1.program_application_id program_application_id, mat1.request_id request_id , mat1.created_by created_by , mat1.creation_date creation_date , mat1.last_updated_by last_updated_by , mat1.last_update_date last_update_date , mat1.last_update_login 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
, NVL(MAT2.ADJ_GROUP_DATE
, MAT1.ADJ_GROUP_DATE) ADJ_GROUP_DATE
, MAT1.MATCH_TYPE_CODE MATCH_TYPE_CODE
, MAT1.SHIP_HEADER_ID SHIP_HEADER_ID
, MAT1.FROM_PARENT_TABLE_NAME FROM_PARENT_TABLE_NAME
, MAT1.FROM_PARENT_TABLE_ID FROM_PARENT_TABLE_ID
, MAT1.TO_PARENT_TABLE_NAME TO_PARENT_TABLE_NAME
, MAT1.TO_PARENT_TABLE_ID TO_PARENT_TABLE_ID
, MAT1.MATCHED_QTY MATCHED_QTY
, MAT1.MATCHED_UOM_CODE 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) MATCHED_AMT
, DECODE(MAT2.MATCH_ID
, MAT1.MATCH_ID
, NULL
, MAT2.MATCH_ID) CORRECTION_MATCH_ID
, MAT1.MATCHED_CURR_CODE MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CONVERSION_TYPE MATCHED_CURR_CONVERSION_TYPE
, MAT1.MATCHED_CURR_CONVERSION_DATE MATCHED_CURR_CONVERSION_DATE
, MAT1.MATCHED_CURR_CONVERSION_RATE MATCHED_CURR_CONVERSION_RATE
, NVL(MAT2.ADJ_ALREADY_GENERATED_FLAG
, MAT1.ADJ_ALREADY_GENERATED_FLAG) ADJ_ALREADY_GENERATED_FLAG
, MAT1.REPLACE_ESTIM_QTY_FLAG REPLACE_ESTIM_QTY_FLAG
, NVL(MAT2.EXISTING_MATCH_INFO_FLAG
, MAT1.EXISTING_MATCH_INFO_FLAG) EXISTING_MATCH_INFO_FLAG
, MAT1.CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID
, MAT1.PARTY_ID PARTY_ID
, MAT1.PARTY_SITE_ID PARTY_SITE_ID
, MAT1.TAX_CODE TAX_CODE
, MAT1.NREC_TAX_AMT NREC_TAX_AMT
, MAT1.TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG
, MAT1.MATCH_AMOUNT_ID MATCH_AMOUNT_ID
, MAT1.PROGRAM_ID PROGRAM_ID
, MAT1.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MAT1.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MAT1.REQUEST_ID REQUEST_ID
, MAT1.CREATED_BY CREATED_BY
, MAT1.CREATION_DATE CREATION_DATE
, MAT1.LAST_UPDATED_BY LAST_UPDATED_BY
, MAT1.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MAT1.LAST_UPDATE_LOGIN 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