VIEW: APPS.ZX_TRANSACTION_LINES_V

Source

View Text - Preformatted

SELECT TRL.ROWID ROW_ID,
          TRL.APPLICATION_ID,
          TRL.ENTITY_CODE,
          TRL.EVENT_CLASS_CODE,
          TRL.TRX_LINE_ID,
          TRL.TRX_LINE_NUMBER,
          TRL.TRX_ID,
          TRL.TRX_LEVEL_TYPE,
          TRL.TRX_LINE_TYPE,
          TRL.TRX_LINE_DATE,
          TRL.TRX_BUSINESS_CATEGORY,
          TRL.LINE_INTENDED_USE,
          TRL.USER_DEFINED_FISC_CLASS,
          TRL.LINE_AMT_INCLUDES_TAX_FLAG,
          TRL.LINE_AMT,
          TRL.TRX_LINE_QUANTITY,
          TRL.UNIT_PRICE,
          TRL.PRODUCT_ID,
          TRL.PRODUCT_FISC_CLASSIFICATION,
          TRL.PRODUCT_ORG_ID,
          ORG.ORGANIZATION_NAME PRODUCT_ORG_DESC,
          TRL.UOM_CODE,
          TRL.PRODUCT_TYPE,
          DECODE(TRL.PRODUCT_TYPE, 'MEMOS', 'MEMOS',
                 PROD.CLASSIFICATION_NAME) PRODUCT_TYPE_DESC,
          TRL.PRODUCT_CODE,
          TRL.PRODUCT_CATEGORY,
          TRL.MERCHANT_PARTY_ID,
          TRL.ACCOUNT_CCID,
          TRL.ACCOUNT_STRING,
          TRL.REF_DOC_LINE_ID,
          TRL.REF_DOC_LINE_QUANTITY,
          TRL.REF_DOC_APPLICATION_ID,
          TRL.REF_DOC_ENTITY_CODE,
          TRL.REF_DOC_EVENT_CLASS_CODE,
          TRL.REF_DOC_TRX_ID,
          TRL.APPLIED_FROM_LINE_ID,
          TRL.APPLIED_FROM_APPLICATION_ID,
          TRL.APPLIED_FROM_ENTITY_CODE,
          TRL.APPLIED_FROM_EVENT_CLASS_CODE,
          TRL.APPLIED_FROM_TRX_ID,
          TRL.ADJUSTED_DOC_LINE_ID,
          TRL.ADJUSTED_DOC_DATE,
          TRL.ADJUSTED_DOC_APPLICATION_ID,
          TRL.ADJUSTED_DOC_ENTITY_CODE,
          TRL.ADJUSTED_DOC_EVENT_CLASS_CODE,
          TRL.ADJUSTED_DOC_TRX_ID,
          TRL.TRX_LINE_DESCRIPTION,
          TRL.PRODUCT_DESCRIPTION,
          TRL.TRX_LINE_GL_DATE,
          TRL.LINE_LEVEL_ACTION,
          TRL.HISTORICAL_FLAG,
          TRL.BILL_FROM_PARTY_SITE_ID,
          TRL.BILL_TO_PARTY_SITE_ID,
          TRL.SHIP_FROM_PARTY_SITE_ID,
          TRL.SHIP_TO_PARTY_SITE_ID,
          TRL.SHIP_TO_PARTY_ID,
          TRL.SHIP_FROM_PARTY_ID,
          TRL.BILL_TO_PARTY_ID,
          TRL.BILL_FROM_PARTY_ID,
          TRL.SHIP_TO_LOCATION_ID,
          TRL.SHIP_FROM_LOCATION_ID,
          TRL.BILL_TO_LOCATION_ID,
          TRL.BILL_FROM_LOCATION_ID,
          TRL.POA_LOCATION_ID,
          TRL.POO_LOCATION_ID,
          TRL.PAYING_LOCATION_ID,
          TRL.OWN_HQ_LOCATION_ID,
          TRL.TRADING_HQ_LOCATION_ID,
          TRL.POC_LOCATION_ID,
          TRL.POI_LOCATION_ID,
          TRL.POD_LOCATION_ID,
          TRL.TAX_REGIME_ID,
          TRL.TAX_REGIME_CODE,
          TRL.TAX_ID,
          TRL.TAX,
          TRL.TAX_STATUS_ID,
          TRL.TAX_STATUS_CODE,
          TRL.TAX_RATE_ID,
          TRL.TAX_RATE_CODE,
          TRL.TAX_RATE,
          TRL.TAX_LINE_AMT,
          TRL.LINE_CLASS,
          TRL.TRX_SHIPPING_DATE,
          TRL.TRX_RECEIPT_DATE,
          TRL.EXEMPT_CERTIFICATE_NUMBER,
          TRL.EXEMPT_REASON,
          TRL.CASH_DISCOUNT,
          TRL.VOLUME_DISCOUNT,
          TRL.TRADING_DISCOUNT,
          TRL.TRANSFER_CHARGE,
          TRL.TRANSPORTATION_CHARGE,
          TRL.INSURANCE_CHARGE,
          TRL.OTHER_CHARGE,
          TRL.POA_PARTY_ID,
          TRL.POO_PARTY_ID,
          TRL.POA_PARTY_SITE_ID,
          TRL.POO_PARTY_SITE_ID,
          TRL.MERCHANT_PARTY_COUNTRY,
          TRL.APPLIED_TO_APPLICATION_ID,
          TRL.APPLIED_TO_ENTITY_CODE,
          TRL.APPLIED_TO_EVENT_CLASS_CODE,
          TRL.APPLIED_TO_TRX_ID,
          TRL.APPLIED_TO_TRX_LINE_ID,
          TRL.CTRL_HDR_TX_APPL_FLAG,
          TRL.CTRL_TOTAL_LINE_TX_AMT,
          TRL.INPUT_TAX_CLASSIFICATION_CODE,
          TRL.OUTPUT_TAX_CLASSIFICATION_CODE,
          TRL.REF_DOC_TRX_LEVEL_TYPE,
          TRL.APPLIED_TO_TRX_LEVEL_TYPE,
          TRL.APPLIED_FROM_TRX_LEVEL_TYPE,
          TRL.ADJUSTED_DOC_TRX_LEVEL_TYPE,
          TRL.EXEMPTION_CONTROL_FLAG,
          TRL.EXEMPT_REASON_CODE,
          TRL.RECEIVABLES_TRX_TYPE_ID,
          TRL.OBJECT_VERSION_NUMBER,
          TRL.CREATED_BY,
          TRL.CREATION_DATE,
          TRL.LAST_UPDATED_BY,
          TRL.LAST_UPDATE_DATE,
          TRL.LAST_UPDATE_LOGIN
     FROM ZX_TRANSACTION_LINES TRL,
          ORG_ORGANIZATION_DEFINITIONS ORG,
          ZX_PRODUCT_TYPES_V PROD
     WHERE TRL.PRODUCT_ORG_ID = ORG.ORGANIZATION_ID(+)
       AND TRL.PRODUCT_TYPE = PROD.CLASSIFICATION_CODE(+)

   

View Text - HTML Formatted

SELECT TRL.ROWID ROW_ID
, TRL.APPLICATION_ID
, TRL.ENTITY_CODE
, TRL.EVENT_CLASS_CODE
, TRL.TRX_LINE_ID
, TRL.TRX_LINE_NUMBER
, TRL.TRX_ID
, TRL.TRX_LEVEL_TYPE
, TRL.TRX_LINE_TYPE
, TRL.TRX_LINE_DATE
, TRL.TRX_BUSINESS_CATEGORY
, TRL.LINE_INTENDED_USE
, TRL.USER_DEFINED_FISC_CLASS
, TRL.LINE_AMT_INCLUDES_TAX_FLAG
, TRL.LINE_AMT
, TRL.TRX_LINE_QUANTITY
, TRL.UNIT_PRICE
, TRL.PRODUCT_ID
, TRL.PRODUCT_FISC_CLASSIFICATION
, TRL.PRODUCT_ORG_ID
, ORG.ORGANIZATION_NAME PRODUCT_ORG_DESC
, TRL.UOM_CODE
, TRL.PRODUCT_TYPE
, DECODE(TRL.PRODUCT_TYPE
, 'MEMOS'
, 'MEMOS'
, PROD.CLASSIFICATION_NAME) PRODUCT_TYPE_DESC
, TRL.PRODUCT_CODE
, TRL.PRODUCT_CATEGORY
, TRL.MERCHANT_PARTY_ID
, TRL.ACCOUNT_CCID
, TRL.ACCOUNT_STRING
, TRL.REF_DOC_LINE_ID
, TRL.REF_DOC_LINE_QUANTITY
, TRL.REF_DOC_APPLICATION_ID
, TRL.REF_DOC_ENTITY_CODE
, TRL.REF_DOC_EVENT_CLASS_CODE
, TRL.REF_DOC_TRX_ID
, TRL.APPLIED_FROM_LINE_ID
, TRL.APPLIED_FROM_APPLICATION_ID
, TRL.APPLIED_FROM_ENTITY_CODE
, TRL.APPLIED_FROM_EVENT_CLASS_CODE
, TRL.APPLIED_FROM_TRX_ID
, TRL.ADJUSTED_DOC_LINE_ID
, TRL.ADJUSTED_DOC_DATE
, TRL.ADJUSTED_DOC_APPLICATION_ID
, TRL.ADJUSTED_DOC_ENTITY_CODE
, TRL.ADJUSTED_DOC_EVENT_CLASS_CODE
, TRL.ADJUSTED_DOC_TRX_ID
, TRL.TRX_LINE_DESCRIPTION
, TRL.PRODUCT_DESCRIPTION
, TRL.TRX_LINE_GL_DATE
, TRL.LINE_LEVEL_ACTION
, TRL.HISTORICAL_FLAG
, TRL.BILL_FROM_PARTY_SITE_ID
, TRL.BILL_TO_PARTY_SITE_ID
, TRL.SHIP_FROM_PARTY_SITE_ID
, TRL.SHIP_TO_PARTY_SITE_ID
, TRL.SHIP_TO_PARTY_ID
, TRL.SHIP_FROM_PARTY_ID
, TRL.BILL_TO_PARTY_ID
, TRL.BILL_FROM_PARTY_ID
, TRL.SHIP_TO_LOCATION_ID
, TRL.SHIP_FROM_LOCATION_ID
, TRL.BILL_TO_LOCATION_ID
, TRL.BILL_FROM_LOCATION_ID
, TRL.POA_LOCATION_ID
, TRL.POO_LOCATION_ID
, TRL.PAYING_LOCATION_ID
, TRL.OWN_HQ_LOCATION_ID
, TRL.TRADING_HQ_LOCATION_ID
, TRL.POC_LOCATION_ID
, TRL.POI_LOCATION_ID
, TRL.POD_LOCATION_ID
, TRL.TAX_REGIME_ID
, TRL.TAX_REGIME_CODE
, TRL.TAX_ID
, TRL.TAX
, TRL.TAX_STATUS_ID
, TRL.TAX_STATUS_CODE
, TRL.TAX_RATE_ID
, TRL.TAX_RATE_CODE
, TRL.TAX_RATE
, TRL.TAX_LINE_AMT
, TRL.LINE_CLASS
, TRL.TRX_SHIPPING_DATE
, TRL.TRX_RECEIPT_DATE
, TRL.EXEMPT_CERTIFICATE_NUMBER
, TRL.EXEMPT_REASON
, TRL.CASH_DISCOUNT
, TRL.VOLUME_DISCOUNT
, TRL.TRADING_DISCOUNT
, TRL.TRANSFER_CHARGE
, TRL.TRANSPORTATION_CHARGE
, TRL.INSURANCE_CHARGE
, TRL.OTHER_CHARGE
, TRL.POA_PARTY_ID
, TRL.POO_PARTY_ID
, TRL.POA_PARTY_SITE_ID
, TRL.POO_PARTY_SITE_ID
, TRL.MERCHANT_PARTY_COUNTRY
, TRL.APPLIED_TO_APPLICATION_ID
, TRL.APPLIED_TO_ENTITY_CODE
, TRL.APPLIED_TO_EVENT_CLASS_CODE
, TRL.APPLIED_TO_TRX_ID
, TRL.APPLIED_TO_TRX_LINE_ID
, TRL.CTRL_HDR_TX_APPL_FLAG
, TRL.CTRL_TOTAL_LINE_TX_AMT
, TRL.INPUT_TAX_CLASSIFICATION_CODE
, TRL.OUTPUT_TAX_CLASSIFICATION_CODE
, TRL.REF_DOC_TRX_LEVEL_TYPE
, TRL.APPLIED_TO_TRX_LEVEL_TYPE
, TRL.APPLIED_FROM_TRX_LEVEL_TYPE
, TRL.ADJUSTED_DOC_TRX_LEVEL_TYPE
, TRL.EXEMPTION_CONTROL_FLAG
, TRL.EXEMPT_REASON_CODE
, TRL.RECEIVABLES_TRX_TYPE_ID
, TRL.OBJECT_VERSION_NUMBER
, TRL.CREATED_BY
, TRL.CREATION_DATE
, TRL.LAST_UPDATED_BY
, TRL.LAST_UPDATE_DATE
, TRL.LAST_UPDATE_LOGIN
FROM ZX_TRANSACTION_LINES TRL
, ORG_ORGANIZATION_DEFINITIONS ORG
, ZX_PRODUCT_TYPES_V PROD
WHERE TRL.PRODUCT_ORG_ID = ORG.ORGANIZATION_ID(+)
AND TRL.PRODUCT_TYPE = PROD.CLASSIFICATION_CODE(+)