VIEW: APPS.INL_ADJ_SHIP_LINES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )