View: INL_ADJ_SHIP_LINES_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows adjusted information on Shipment Lines.
Implementation/DBA Data:	APPS.INL_ADJ_SHIP_LINES_V

View Text

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

Columns