VIEW: APPS.INL_CHARGE_OVERALL_V

Source

View Text - Preformatted

SELECT ish.ship_header_id, ish.organization_id, ish.location_id, ish.org_id, ish.ship_type_id, ish.ship_num, ish.ship_date, ish.ship_status_code, ish.pending_matching_flag, ilg.party_id line_group_party_id, ilg.party_site_id line_group_party_site_id, icl.charge_line_id, icl.charge_line_num, icl.charge_line_type_id, icl.landed_cost_flag, icl.parent_charge_line_id, icl.adjustment_num, icl.match_id, icl.charge_amt, icl.currency_code, icl.currency_conversion_type, icl.currency_conversion_date, icl.currency_conversion_rate, icl.party_id, hp.party_name group_party_name, icl.party_site_id, hps.party_site_name group_party_site_name, icl.trx_business_category, icl.intended_use, icl.product_fiscal_class, icl.product_category, icl.product_type, icl.user_def_fiscal_class, icl.tax_classification_code, icl.assessable_value, icl.tax_already_calculated_flag, icl.ship_from_party_id, icl.ship_from_party_site_id, icl.ship_to_organization_id, icl.ship_to_location_id, icl.bill_from_party_id, icl.bill_from_party_site_id, icl.bill_to_organization_id, icl.bill_to_location_id, icl.poa_party_id, icl.poa_party_site_id, icl.poo_organization_id, icl.poo_location_id FROM hz_party_sites hps, hz_parties hp, inl_adj_charge_lines_v icl, inl_ship_line_groups ilg, inl_ship_headers ish   WHERE hps.party_site_id (+) = icl.party_site_id AND hp.party_id (+) = icl.party_id AND NVL(icl.parent_charge_line_id,icl.charge_line_id) IN (SELECT assoc.from_parent_table_id FROM inl_associations assoc WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES' AND assoc.ship_header_id = ish.ship_header_id) AND ilg.ship_header_id (+) = ish.ship_header_id

View Text - HTML Formatted

SELECT ISH.SHIP_HEADER_ID
, ISH.ORGANIZATION_ID
, ISH.LOCATION_ID
, ISH.ORG_ID
, ISH.SHIP_TYPE_ID
, ISH.SHIP_NUM
, ISH.SHIP_DATE
, ISH.SHIP_STATUS_CODE
, ISH.PENDING_MATCHING_FLAG
, ILG.PARTY_ID LINE_GROUP_PARTY_ID
, ILG.PARTY_SITE_ID LINE_GROUP_PARTY_SITE_ID
, ICL.CHARGE_LINE_ID
, ICL.CHARGE_LINE_NUM
, ICL.CHARGE_LINE_TYPE_ID
, ICL.LANDED_COST_FLAG
, ICL.PARENT_CHARGE_LINE_ID
, ICL.ADJUSTMENT_NUM
, ICL.MATCH_ID
, ICL.CHARGE_AMT
, ICL.CURRENCY_CODE
, ICL.CURRENCY_CONVERSION_TYPE
, ICL.CURRENCY_CONVERSION_DATE
, ICL.CURRENCY_CONVERSION_RATE
, ICL.PARTY_ID
, HP.PARTY_NAME GROUP_PARTY_NAME
, ICL.PARTY_SITE_ID
, HPS.PARTY_SITE_NAME GROUP_PARTY_SITE_NAME
, ICL.TRX_BUSINESS_CATEGORY
, ICL.INTENDED_USE
, ICL.PRODUCT_FISCAL_CLASS
, ICL.PRODUCT_CATEGORY
, ICL.PRODUCT_TYPE
, ICL.USER_DEF_FISCAL_CLASS
, ICL.TAX_CLASSIFICATION_CODE
, ICL.ASSESSABLE_VALUE
, ICL.TAX_ALREADY_CALCULATED_FLAG
, ICL.SHIP_FROM_PARTY_ID
, ICL.SHIP_FROM_PARTY_SITE_ID
, ICL.SHIP_TO_ORGANIZATION_ID
, ICL.SHIP_TO_LOCATION_ID
, ICL.BILL_FROM_PARTY_ID
, ICL.BILL_FROM_PARTY_SITE_ID
, ICL.BILL_TO_ORGANIZATION_ID
, ICL.BILL_TO_LOCATION_ID
, ICL.POA_PARTY_ID
, ICL.POA_PARTY_SITE_ID
, ICL.POO_ORGANIZATION_ID
, ICL.POO_LOCATION_ID
FROM HZ_PARTY_SITES HPS
, HZ_PARTIES HP
, INL_ADJ_CHARGE_LINES_V ICL
, INL_SHIP_LINE_GROUPS ILG
, INL_SHIP_HEADERS ISH
WHERE HPS.PARTY_SITE_ID (+) = ICL.PARTY_SITE_ID
AND HP.PARTY_ID (+) = ICL.PARTY_ID
AND NVL(ICL.PARENT_CHARGE_LINE_ID
, ICL.CHARGE_LINE_ID) IN (SELECT ASSOC.FROM_PARENT_TABLE_ID
FROM INL_ASSOCIATIONS ASSOC
WHERE ASSOC.FROM_PARENT_TABLE_NAME = 'INL_CHARGE_LINES'
AND ASSOC.SHIP_HEADER_ID = ISH.SHIP_HEADER_ID)
AND ILG.SHIP_HEADER_ID (+) = ISH.SHIP_HEADER_ID