View: INL_CHARGE_OVERALL_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows overall information on Charges.
Implementation/DBA Data:	APPS.INL_CHARGE_OVERALL_V

View Text

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
FROM INL_ADJ_CHARGE_LINES_V ICL
, INL_SHIP_LINE_GROUPS ILG
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

Columns