VIEW: APPS.QPR_PN_REQUEST_HDRS_VL

Source

View Text - Preformatted

SELECT b.REQUEST_HEADER_ID, b.request_status, tl.reference_name, b.instance_id, b.CUSTOMER_SK, b.SALES_CHANNEL_SK, b.SALES_REP_SK, b.PN_INT_HEADER_ID, b.SOURCE_ID, b.SOURCE_REF_HDR_ID, b.CUSTOMER_ID, b.SALES_REP_ID, b.PAYMENT_TERMS_ID, b.INVOICE_TO_PARTY_SITE_ID, b.SALES_REP_EMAIL, b.SALES_CHANNEL_CODE, b.DEAL_EXPIRY_date, b.DEAL_CREATION_date, b.INVOICE_TO_PARTY_SITE_ADDRESS, b.CURRENCY_SHORT_DESC, b.CURRENCY_LONG_DESC, b.SOURCE_SHORT_DESC, b.SOURCE_LONG_DESC, b.SOURCE_REF_HDR_SHORT_DESC, b.SOURCE_REF_HDR_LONG_DESC, b.CUSTOMER_SHORT_DESC, b.CUSTOMER_LONG_DESC, b.SALES_REP_SHORT_DESC, b.SALES_REP_LONG_DESC, b.SALES_CHANNEL_SHORT_DESC, b.SALES_CHANNEL_LONG_DESC, b.FREIGHT_TERMS_SHORT_DESC, b.FREIGHT_TERMS_LONG_DESC, b.PAYMENT_TERMS_SHORT_DESC, b.PAYMENT_TERMS_LONG_DESC, b.COMMENTS, b.SIMULATION_FLAG, b.CREATION_date, b.CREATED_BY , b.LAST_UPDATE_date, b.LAST_UPDated_BY, b.LAST_UPdate_LOGIN FROM QPR_PN_REQUEST_HDRS_B b, QPR_PN_REQUEST_HDRS_TL tl WHERE b.request_header_id = tl.request_header_id AND tl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.REQUEST_HEADER_ID
, B.REQUEST_STATUS
, TL.REFERENCE_NAME
, B.INSTANCE_ID
, B.CUSTOMER_SK
, B.SALES_CHANNEL_SK
, B.SALES_REP_SK
, B.PN_INT_HEADER_ID
, B.SOURCE_ID
, B.SOURCE_REF_HDR_ID
, B.CUSTOMER_ID
, B.SALES_REP_ID
, B.PAYMENT_TERMS_ID
, B.INVOICE_TO_PARTY_SITE_ID
, B.SALES_REP_EMAIL
, B.SALES_CHANNEL_CODE
, B.DEAL_EXPIRY_DATE
, B.DEAL_CREATION_DATE
, B.INVOICE_TO_PARTY_SITE_ADDRESS
, B.CURRENCY_SHORT_DESC
, B.CURRENCY_LONG_DESC
, B.SOURCE_SHORT_DESC
, B.SOURCE_LONG_DESC
, B.SOURCE_REF_HDR_SHORT_DESC
, B.SOURCE_REF_HDR_LONG_DESC
, B.CUSTOMER_SHORT_DESC
, B.CUSTOMER_LONG_DESC
, B.SALES_REP_SHORT_DESC
, B.SALES_REP_LONG_DESC
, B.SALES_CHANNEL_SHORT_DESC
, B.SALES_CHANNEL_LONG_DESC
, B.FREIGHT_TERMS_SHORT_DESC
, B.FREIGHT_TERMS_LONG_DESC
, B.PAYMENT_TERMS_SHORT_DESC
, B.PAYMENT_TERMS_LONG_DESC
, B.COMMENTS
, B.SIMULATION_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM QPR_PN_REQUEST_HDRS_B B
, QPR_PN_REQUEST_HDRS_TL TL
WHERE B.REQUEST_HEADER_ID = TL.REQUEST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')