VIEW: APPS.INL_ADJ_SHIP_LINES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )