eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PON_SGD_AMD_HEADERS_UDA_V

Source

View Text - Preformatted


SELECT ponext.auction_header_id pk1_value, null pk2_value, null pk3_value, null pk4_value, null pk5_value, ega.col_name , ponext.col_value, decode(ega.attr_name, 'AQ_PLAN', (select c.contract_name from okc_rep_contracts_all c, okc_bus_doc_types_b db, okc_bus_doc_types_tl dtl where c.contract_type = db.document_type and dtl.document_type = db.document_type and dtl.name = 'Acquisition Plan Summary' and dtl.language = userenv('lang') and contract_id = ponext.col_value), 'CUST_PROJ_CODE', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_CUSTOMER_PROJECT_CODE' and lookup_code = ponext.col_value), 'PRIORITY', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_PRIORITY_CODE' and lookup_code = ponext.col_value), 'DPAS_RATING', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_DPAS_RATING' and lookup_code = ponext.col_value), 'SET_ASIDE_TYPE', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_SET_ASIDE_TYPE' and lookup_code = ponext.col_value), 'SIZE_STANDARD', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_SIZE_STANDARD' and lookup_code = ponext.col_value), 'SET_ASIDE_STAT', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_SET_ASIDE_STATUS' and lookup_code = ponext.col_value), 'NAICS', (select meaning from fnd_lookup_values where lookup_type = 'FV_NAICS_TYPE' and lookup_code = ponext.col_value and language = userenv('lang')), 'PERIOD_STATUS', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_PERIOD_STATUS' and lookup_code = ponext.col_value), 'BOND_REQUIRED', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_BOND_REQUIRED_YN' and lookup_code = ponext.col_value), null) col_desc from ( select fcu.descriptive_flex_context_code attr_group_name, fcu.application_column_name , upper(fcu.descriptive_flex_context_code || '_' || fcu.end_user_column_name) col_name, upper(fcu.end_user_column_name) attr_name from fnd_descr_flex_column_usages fcu where fcu.descriptive_flexfield_name = 'PON_AUC_HDRS_EXT_ATTRS' and fcu.application_id = 201 and fcu.display_flag <> 'H' ) ega , ( With pon_header_ext_unpivot_data as ( select auction_header_id, egg.descriptive_flex_context_code attr_group_name, C_EXT_ATTR1, C_EXT_ATTR2, C_EXT_ATTR3, C_EXT_ATTR4, C_EXT_ATTR5, C_EXT_ATTR6, C_EXT_ATTR7 from pon_auction_headers_ext_b ext, ego_fnd_dsc_flx_ctx_ext egg where ext.auction_header_id = PO_GEN_DIFF_PKG.getModPK1 and ext.attr_group_id = egg.attr_group_id and egg.descriptive_flexfield_name = 'PON_AUC_HDRS_EXT_ATTRS' and egg.application_id = 201 and egg.descriptive_flex_context_code IN ('AQ_PLAN1','BU_PRI_PRJ_INF', 'SET_ASIDE_INFO', 'SF1442_Informa') ) select auction_header_id, attr_group_name, col_name, col_value from pon_header_ext_unpivot_data unpivot include nulls (col_value for col_name in ( C_EXT_ATTR1, C_EXT_ATTR2, C_EXT_ATTR3, C_EXT_ATTR4, C_EXT_ATTR5, C_EXT_ATTR6, C_EXT_ATTR7 ) ) ) ponext where ega.attr_group_name = ponext.attr_group_name and ega.application_column_name = ponext.col_name

View Text - HTML Formatted

SELECT PONEXT.AUCTION_HEADER_ID PK1_VALUE
, NULL PK2_VALUE
, NULL PK3_VALUE
, NULL PK4_VALUE
, NULL PK5_VALUE
, EGA.COL_NAME
, PONEXT.COL_VALUE
, DECODE(EGA.ATTR_NAME
, 'AQ_PLAN'
, (SELECT C.CONTRACT_NAME
FROM OKC_REP_CONTRACTS_ALL C
, OKC_BUS_DOC_TYPES_B DB
, OKC_BUS_DOC_TYPES_TL DTL
WHERE C.CONTRACT_TYPE = DB.DOCUMENT_TYPE
AND DTL.DOCUMENT_TYPE = DB.DOCUMENT_TYPE
AND DTL.NAME = 'ACQUISITION PLAN SUMMARY'
AND DTL.LANGUAGE = USERENV('LANG')
AND CONTRACT_ID = PONEXT.COL_VALUE)
, 'CUST_PROJ_CODE'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'PRIORITY'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_PRIORITY_CODE'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'DPAS_RATING'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_DPAS_RATING'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'SET_ASIDE_TYPE'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_SET_ASIDE_TYPE'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'SIZE_STANDARD'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_SIZE_STANDARD'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'SET_ASIDE_STAT'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_SET_ASIDE_STATUS'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'NAICS'
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'FV_NAICS_TYPE'
AND LOOKUP_CODE = PONEXT.COL_VALUE
AND LANGUAGE = USERENV('LANG'))
, 'PERIOD_STATUS'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_PERIOD_STATUS'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, 'BOND_REQUIRED'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_BOND_REQUIRED_YN'
AND LOOKUP_CODE = PONEXT.COL_VALUE)
, NULL) COL_DESC
FROM ( SELECT FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP_NAME
, FCU.APPLICATION_COLUMN_NAME
, UPPER(FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE || '_' || FCU.END_USER_COLUMN_NAME) COL_NAME
, UPPER(FCU.END_USER_COLUMN_NAME) ATTR_NAME
FROM FND_DESCR_FLEX_COLUMN_USAGES FCU
WHERE FCU.DESCRIPTIVE_FLEXFIELD_NAME = 'PON_AUC_HDRS_EXT_ATTRS'
AND FCU.APPLICATION_ID = 201
AND FCU.DISPLAY_FLAG <> 'H' ) EGA
, ( WITH PON_HEADER_EXT_UNPIVOT_DATA AS ( SELECT AUCTION_HEADER_ID
, EGG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP_NAME
, C_EXT_ATTR1
, C_EXT_ATTR2
, C_EXT_ATTR3
, C_EXT_ATTR4
, C_EXT_ATTR5
, C_EXT_ATTR6
, C_EXT_ATTR7
FROM PON_AUCTION_HEADERS_EXT_B EXT
, EGO_FND_DSC_FLX_CTX_EXT EGG
WHERE EXT.AUCTION_HEADER_ID = PO_GEN_DIFF_PKG.GETMODPK1
AND EXT.ATTR_GROUP_ID = EGG.ATTR_GROUP_ID
AND EGG.DESCRIPTIVE_FLEXFIELD_NAME = 'PON_AUC_HDRS_EXT_ATTRS'
AND EGG.APPLICATION_ID = 201
AND EGG.DESCRIPTIVE_FLEX_CONTEXT_CODE IN ('AQ_PLAN1'
, 'BU_PRI_PRJ_INF'
, 'SET_ASIDE_INFO'
, 'SF1442_INFORMA') ) SELECT AUCTION_HEADER_ID
, ATTR_GROUP_NAME
, COL_NAME
, COL_VALUE
FROM PON_HEADER_EXT_UNPIVOT_DATA UNPIVOT INCLUDE NULLS (COL_VALUE FOR COL_NAME IN ( C_EXT_ATTR1
, C_EXT_ATTR2
, C_EXT_ATTR3
, C_EXT_ATTR4
, C_EXT_ATTR5
, C_EXT_ATTR6
, C_EXT_ATTR7 ) ) ) PONEXT
WHERE EGA.ATTR_GROUP_NAME = PONEXT.ATTR_GROUP_NAME
AND EGA.APPLICATION_COLUMN_NAME = PONEXT.COL_NAME