View: PON_SYSTEM_FIELDS_VALUES_V

Product:	PON - Sourcing
Description:	View to query up the values for all system fields in a Form associated with a Negotiation
Implementation/DBA Data:	APPS.PON_SYSTEM_FIELDS_VALUES_V

View Text

SELECT AH.AUCTION_HEADER_ID AUCTION_HEADER_ID
, AH.DOCUMENT_NUMBER NEGOTIATION_NUM
, DOC.INTERNAL_NAME NEGOTIATION_TYPE
, DOCTL.NAME NEGOTIATION_TYPE_NAME
, AH.ORG_ID ORGANIZATION
, ORG.NAME ORGANIZATION_NAME
, AH.OPEN_BIDDING_DATE OPEN_DATE
, AH.VIEW_BY_DATE PREVIEW_DATE
, AH.AWARD_BY_DATE AWARD_DATE
, AH.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
, AH.CLOSE_BIDDING_DATE CLOSE_DATE
, AH.AUCTION_TITLE TITLE
, AH.BID_VISIBILITY_CODE STYLE
, LOOKUP_1.MEANING STYLE_NAME
, AH.TRADING_PARTNER_NAME BUYER
, AH.EVENT_TITLE EVENT
, AH.PAYMENT_TERMS_ID PAYMENT_TERMS
, ATVL_1.NAME PAYMENT_TERMS_NAME
, AH.CARRIER_CODE CARRIER
, PON_FORMS_UTIL_PVT.GET_FREIGHT(AH.CARRIER_CODE
, FSP.INVENTORY_ORGANIZATION_ID) CARRIER_NAME
, AH.FOB_CODE FOB
, LOOKUP_2.MEANING FOB_NAME
, AH.FREIGHT_TERMS_CODE FREIGHT_TERMS
, LOOKUP_3.MEANING FREIGHT_TERMS_NAME
, AH.CURRENCY_CODE NEGOTIATION_CURR
, AH.ABSTRACT_STATUS ABSTRACT_STATUS
, DECODE( NVL(AH.INCLUDE_PDF_IN_EXTERNAL_PAGE
, 'N')
, 'Y'
, 'SHOW_PDF'
, 'HIDE_PDF') DISPLAY_PDF_FLAG
, AH.IS_PAUSED IS_PAUSED
, AH.TWO_PART_FLAG FROM PON_AUCTION_HEADERS_ALL AH
, PON_AUC_DOCTYPES DOC
, PON_AUC_DOCTYPES_TL DOCTL
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, AP_TERMS_VL ATVL_1
, FND_LOOKUP_VALUES LOOKUP_1
, FND_LOOKUP_VALUES LOOKUP_2
, FND_LOOKUP_VALUES LOOKUP_3
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE AH.DOCTYPE_ID = DOC.DOCTYPE_ID AND AH.DOCTYPE_ID = DOCTL.DOCTYPE_ID AND DOCTL.LANGUAGE = USERENV('LANG') AND ORG.ORGANIZATION_ID = AH.ORG_ID AND ORG.LANGUAGE = USERENV('LANG') AND ATVL_1.TERM_ID(+) = AH.PAYMENT_TERMS_ID
AND FSP.ORG_ID(+) = AH.ORG_ID AND LOOKUP_1.LOOKUP_CODE(+) = AH.BID_VISIBILITY_CODE AND LOOKUP_1.LOOKUP_TYPE(+) = 'PON_BID_VISIBILITY_CODE' AND LOOKUP_1.LANGUAGE(+) = USERENV('LANG') AND LOOKUP_2.LOOKUP_CODE(+) = AH.FOB_CODE AND LOOKUP_2.LOOKUP_TYPE(+) = 'FOB' AND LOOKUP_2.LANGUAGE(+) = USERENV('LANG') AND LOOKUP_2.VIEW_APPLICATION_ID(+) = 201 AND LOOKUP_3.LOOKUP_TYPE(+) = 'FREIGHT TERM' AND LOOKUP_3.LOOKUP_CODE(+) = AH.FREIGHT_TERMS_CODE AND LOOKUP_3.LANGUAGE(+) = USERENV('LANG') AND LOOKUP_3.VIEW_APPLICATION_ID(+) = 201

Columns