View: INL_ADJ_SHIP_LINES_V

Product:	INL - Oracle Landed Cost Management
Description:
Implementation/DBA Data:	APPS.INL_ADJ_SHIP_LINES_V

View Text

SELECT OPL1.SHIP_HEADER_ID
, OPL1.SHIP_LINE_GROUP_ID
, OPL1.SHIP_LINE_ID
, OPL1.SHIP_LINE_NUM
, OPL1.SHIP_LINE_TYPE_ID
, OPL1.SHIP_LINE_SRC_TYPE_CODE
, OPL1.SHIP_LINE_SOURCE_ID
, OPL1.PARENT_SHIP_LINE_ID
, OPL1.ADJUSTMENT_NUM
, OPL1.MATCH_ID
, OPL1.CURRENCY_CODE
, OPL1.CURRENCY_CONVERSION_TYPE
, OPL1.CURRENCY_CONVERSION_DATE
, OPL1.CURRENCY_CONVERSION_RATE
, OPL1.INVENTORY_ITEM_ID
, OPL1.TXN_QTY
, OPL1.TXN_UOM_CODE
, OPL1.TXN_UNIT_PRICE
, OPL1.PRIMARY_QTY
, OPL1.PRIMARY_UOM_CODE
, OPL1.PRIMARY_UNIT_PRICE
, PRIMARY_UNIT_PRICE * NVL(CURRENCY_CONVERSION_RATE
, 1) FC_PRIMARY_UNIT_PRICE
, OPL1.SECONDARY_QTY
, OPL1.SECONDARY_UOM_CODE
, OPL1.SECONDARY_UNIT_PRICE
, OPL1.LANDED_COST_FLAG
, OPL1.ALLOCATION_ENABLED_FLAG
, OPL1.TRX_BUSINESS_CATEGORY
, OPL1.INTENDED_USE
, OPL1.PRODUCT_FISCAL_CLASS
, OPL1.PRODUCT_CATEGORY
, OPL1.PRODUCT_TYPE
, OPL1.USER_DEF_FISCAL_CLASS
, OPL1.TAX_CLASSIFICATION_CODE
, OPL1.ASSESSABLE_VALUE
, OPL1.TAX_ALREADY_CALCULATED_FLAG
, OPL1.SHIP_FROM_PARTY_ID
, OPL1.SHIP_FROM_PARTY_SITE_ID
, OPL1.SHIP_TO_ORGANIZATION_ID
, OPL1.SHIP_TO_LOCATION_ID
, OPL1.BILL_FROM_PARTY_ID
, OPL1.BILL_FROM_PARTY_SITE_ID
, OPL1.BILL_TO_ORGANIZATION_ID
, OPL1.BILL_TO_LOCATION_ID
, OPL1.POA_PARTY_ID
, OPL1.POA_PARTY_SITE_ID
, OPL1.POO_ORGANIZATION_ID
, OPL1.POO_LOCATION_ID
, OPL1.ORG_ID
, OPL1.ATTRIBUTE_CATEGORY
, OPL1.ATTRIBUTE1
, OPL1.ATTRIBUTE2
, OPL1.ATTRIBUTE3
, OPL1.ATTRIBUTE4
, OPL1.ATTRIBUTE5
, OPL1.ATTRIBUTE6
, OPL1.ATTRIBUTE7
, OPL1.ATTRIBUTE8
, OPL1.ATTRIBUTE9
, OPL1.ATTRIBUTE10
, OPL1.ATTRIBUTE11
, OPL1.ATTRIBUTE12
, OPL1.ATTRIBUTE13
, OPL1.ATTRIBUTE14
, OPL1.ATTRIBUTE15
FROM INL_SHIP_LINES_ALL OPL1
WHERE OPL1.SHIP_LINE_ID = (SELECT MAX(OPL2.SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL OPL2
WHERE OPL2.SHIP_HEADER_ID = OPL1.SHIP_HEADER_ID
AND OPL2.SHIP_LINE_GROUP_ID = OPL1.SHIP_LINE_GROUP_ID
AND OPL2.SHIP_LINE_NUM = OPL1.SHIP_LINE_NUM )

Columns