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.PO_SGD_MOD_LINELOCS_UDA_V

Source

View Text - Preformatted


SELECT poext.po_header_id pk1_value, poext.draft_id pk2_value, poext.po_line_id pk3_value, poext.line_location_id pk4_value, null pk5_value, ega.col_name , poext.col_value, decode(ega.attr_name, 'HAZMAT', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_HAZMAT' and lookup_code = poext.col_value), 'FOB', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_FOB_VALUES' and lookup_code = poext.col_value), 'SHIP_MODE', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_SHIPMENT_MODES' and lookup_code = poext.col_value), 'PREC_MTL_CODE', (select displayed_field from po_lookup_codes where lookup_type = 'PO_CLM_PRECIOUS_METAL_CODE' and lookup_code = poext.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.application_id = 201 and fcu.descriptive_flexfield_name = 'PO_SHIPMENTS_EXT_ATTRS' and fcu.display_flag <> 'H' ) ega , ( With po_lineloc_ext_unpivot_data as ( select lloc.po_header_id, lloc.draft_id, lloc.po_line_id, lloc.line_location_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, C_EXT_ATTR8, C_EXT_ATTR9, C_EXT_ATTR10, C_EXT_ATTR11, C_EXT_ATTR12, C_EXT_ATTR13 from po_line_locations_all_ext_b ext, po_line_locations_draft_all lloc, ego_fnd_dsc_flx_ctx_ext egg where ext.line_location_id = lloc.line_location_id and ext.draft_id = lloc.draft_id and lloc.po_header_id = PO_GEN_DIFF_PKG.getModPK1 and lloc.draft_id = PO_GEN_DIFF_PKG.getModPK2 and lloc.po_line_id = nvl(PO_GEN_DIFF_PKG.getModPK3, lloc.po_line_id) and lloc.line_location_id = nvl(PO_GEN_DIFF_PKG.getModPK4, lloc.line_location_id) and lloc.change_status IN ('UPDATE') and egg.descriptive_flexfield_name = 'PO_SHIPMENTS_EXT_ATTRS' and egg.descriptive_flex_context_code = 'SHIP_INFO' and egg.application_id = 201 and ext.attr_group_id = egg.attr_group_id ) select po_header_id, draft_id, po_line_id, line_location_id, attr_group_name , col_name, col_value from po_lineloc_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, C_EXT_ATTR8, C_EXT_ATTR9, C_EXT_ATTR10, C_EXT_ATTR11, C_EXT_ATTR12, C_EXT_ATTR13 ) ) ) poext where ega.attr_group_name = poext.attr_group_name and ega.application_column_name = poext.col_name

View Text - HTML Formatted

SELECT POEXT.PO_HEADER_ID PK1_VALUE
, POEXT.DRAFT_ID PK2_VALUE
, POEXT.PO_LINE_ID PK3_VALUE
, POEXT.LINE_LOCATION_ID PK4_VALUE
, NULL PK5_VALUE
, EGA.COL_NAME
, POEXT.COL_VALUE
, DECODE(EGA.ATTR_NAME
, 'HAZMAT'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_HAZMAT'
AND LOOKUP_CODE = POEXT.COL_VALUE)
, 'FOB'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_FOB_VALUES'
AND LOOKUP_CODE = POEXT.COL_VALUE)
, 'SHIP_MODE'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_SHIPMENT_MODES'
AND LOOKUP_CODE = POEXT.COL_VALUE)
, 'PREC_MTL_CODE'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'PO_CLM_PRECIOUS_METAL_CODE'
AND LOOKUP_CODE = POEXT.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.APPLICATION_ID = 201
AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_SHIPMENTS_EXT_ATTRS'
AND FCU.DISPLAY_FLAG <> 'H' ) EGA
, ( WITH PO_LINELOC_EXT_UNPIVOT_DATA AS ( SELECT LLOC.PO_HEADER_ID
, LLOC.DRAFT_ID
, LLOC.PO_LINE_ID
, LLOC.LINE_LOCATION_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
, C_EXT_ATTR8
, C_EXT_ATTR9
, C_EXT_ATTR10
, C_EXT_ATTR11
, C_EXT_ATTR12
, C_EXT_ATTR13
FROM PO_LINE_LOCATIONS_ALL_EXT_B EXT
, PO_LINE_LOCATIONS_DRAFT_ALL LLOC
, EGO_FND_DSC_FLX_CTX_EXT EGG
WHERE EXT.LINE_LOCATION_ID = LLOC.LINE_LOCATION_ID
AND EXT.DRAFT_ID = LLOC.DRAFT_ID
AND LLOC.PO_HEADER_ID = PO_GEN_DIFF_PKG.GETMODPK1
AND LLOC.DRAFT_ID = PO_GEN_DIFF_PKG.GETMODPK2
AND LLOC.PO_LINE_ID = NVL(PO_GEN_DIFF_PKG.GETMODPK3
, LLOC.PO_LINE_ID)
AND LLOC.LINE_LOCATION_ID = NVL(PO_GEN_DIFF_PKG.GETMODPK4
, LLOC.LINE_LOCATION_ID)
AND LLOC.CHANGE_STATUS IN ('UPDATE')
AND EGG.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_SHIPMENTS_EXT_ATTRS'
AND EGG.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'SHIP_INFO'
AND EGG.APPLICATION_ID = 201
AND EXT.ATTR_GROUP_ID = EGG.ATTR_GROUP_ID ) SELECT PO_HEADER_ID
, DRAFT_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, ATTR_GROUP_NAME
, COL_NAME
, COL_VALUE
FROM PO_LINELOC_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
, C_EXT_ATTR8
, C_EXT_ATTR9
, C_EXT_ATTR10
, C_EXT_ATTR11
, C_EXT_ATTR12
, C_EXT_ATTR13 ) ) ) POEXT
WHERE EGA.ATTR_GROUP_NAME = POEXT.ATTR_GROUP_NAME
AND EGA.APPLICATION_COLUMN_NAME = POEXT.COL_NAME