VIEW: APPS.PON_SYSTEM_FIELDS_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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