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_LINES_EXT_MERGE_V

Source

View Text - Preformatted


SELECT PO_LINE_ID, DRAFT_ID, EXTENSION_ID, ATTR_GROUP_ID, DATA_LEVEL_ID, PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, 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, C_EXT_ATTR14, C_EXT_ATTR15, C_EXT_ATTR16, C_EXT_ATTR17, C_EXT_ATTR18, C_EXT_ATTR19, C_EXT_ATTR20, C_EXT_ATTR21, C_EXT_ATTR22, C_EXT_ATTR23, C_EXT_ATTR24, C_EXT_ATTR25, C_EXT_ATTR26, C_EXT_ATTR27, C_EXT_ATTR28, C_EXT_ATTR29, C_EXT_ATTR30, C_EXT_ATTR31, C_EXT_ATTR32, C_EXT_ATTR33, C_EXT_ATTR34, C_EXT_ATTR35, C_EXT_ATTR36, C_EXT_ATTR37, C_EXT_ATTR38, C_EXT_ATTR39, C_EXT_ATTR40, N_EXT_ATTR1, N_EXT_ATTR2, N_EXT_ATTR3, N_EXT_ATTR4, N_EXT_ATTR5, N_EXT_ATTR6, N_EXT_ATTR7, N_EXT_ATTR8, N_EXT_ATTR9, N_EXT_ATTR10, N_EXT_ATTR11, N_EXT_ATTR12, N_EXT_ATTR13, N_EXT_ATTR14, N_EXT_ATTR15, N_EXT_ATTR16, N_EXT_ATTR17, N_EXT_ATTR18, N_EXT_ATTR19, N_EXT_ATTR20, UOM_EXT_ATTR1, UOM_EXT_ATTR2, UOM_EXT_ATTR3, UOM_EXT_ATTR4, UOM_EXT_ATTR5, UOM_EXT_ATTR6, UOM_EXT_ATTR7, UOM_EXT_ATTR8, UOM_EXT_ATTR9, UOM_EXT_ATTR10, UOM_EXT_ATTR11, UOM_EXT_ATTR12, UOM_EXT_ATTR13, UOM_EXT_ATTR14, UOM_EXT_ATTR15, UOM_EXT_ATTR16, UOM_EXT_ATTR17, UOM_EXT_ATTR18, UOM_EXT_ATTR19, UOM_EXT_ATTR20, D_EXT_ATTR1, D_EXT_ATTR2, D_EXT_ATTR3, D_EXT_ATTR4, D_EXT_ATTR5, D_EXT_ATTR6, D_EXT_ATTR7, D_EXT_ATTR8, D_EXT_ATTR9, D_EXT_ATTR10, UDA_TEMPLATE_ID FROM ( SELECT le.po_line_id, le.draft_id , le.EXTENSION_ID, le.ATTR_GROUP_ID, le.DATA_LEVEL_ID, le.PK1_VALUE, le.PK2_VALUE, le.PK3_VALUE, le.PK4_VALUE, le.PK5_VALUE, le.LAST_UPDATE_DATE, le.LAST_UPDATED_BY, le.LAST_UPDATE_LOGIN, le.CREATED_BY, le.CREATION_DATE, le.C_EXT_ATTR1, le.C_EXT_ATTR2, le.C_EXT_ATTR3, le.C_EXT_ATTR4, le.C_EXT_ATTR5, le.C_EXT_ATTR6, le.C_EXT_ATTR7, le.C_EXT_ATTR8, le.C_EXT_ATTR9, le.C_EXT_ATTR10, le.C_EXT_ATTR11, le.C_EXT_ATTR12, le.C_EXT_ATTR13, le.C_EXT_ATTR14, le.C_EXT_ATTR15, le.C_EXT_ATTR16, le.C_EXT_ATTR17, le.C_EXT_ATTR18, le.C_EXT_ATTR19, le.C_EXT_ATTR20, le.C_EXT_ATTR21, le.C_EXT_ATTR22, le.C_EXT_ATTR23, le.C_EXT_ATTR24, le.C_EXT_ATTR25, le.C_EXT_ATTR26, le.C_EXT_ATTR27, le.C_EXT_ATTR28, le.C_EXT_ATTR29, le.C_EXT_ATTR30, le.C_EXT_ATTR31, le.C_EXT_ATTR32, le.C_EXT_ATTR33, le.C_EXT_ATTR34, le.C_EXT_ATTR35, le.C_EXT_ATTR36, le.C_EXT_ATTR37, le.C_EXT_ATTR38, le.C_EXT_ATTR39, le.C_EXT_ATTR40, le.N_EXT_ATTR1, le.N_EXT_ATTR2, le.N_EXT_ATTR3, le.N_EXT_ATTR4, le.N_EXT_ATTR5, le.N_EXT_ATTR6, le.N_EXT_ATTR7, le.N_EXT_ATTR8, le.N_EXT_ATTR9, le.N_EXT_ATTR10, le.N_EXT_ATTR11, le.N_EXT_ATTR12, le.N_EXT_ATTR13, le.N_EXT_ATTR14, le.N_EXT_ATTR15, le.N_EXT_ATTR16, le.N_EXT_ATTR17, le.N_EXT_ATTR18, le.N_EXT_ATTR19, le.N_EXT_ATTR20, le.UOM_EXT_ATTR1, le.UOM_EXT_ATTR2, le.UOM_EXT_ATTR3, le.UOM_EXT_ATTR4, le.UOM_EXT_ATTR5, le.UOM_EXT_ATTR6, le.UOM_EXT_ATTR7, le.UOM_EXT_ATTR8, le.UOM_EXT_ATTR9, le.UOM_EXT_ATTR10, le.UOM_EXT_ATTR11, le.UOM_EXT_ATTR12, le.UOM_EXT_ATTR13, le.UOM_EXT_ATTR14, le.UOM_EXT_ATTR15, le.UOM_EXT_ATTR16, le.UOM_EXT_ATTR17, le.UOM_EXT_ATTR18, le.UOM_EXT_ATTR19, le.UOM_EXT_ATTR20, le.D_EXT_ATTR1, le.D_EXT_ATTR2, le.D_EXT_ATTR3, le.D_EXT_ATTR4, le.D_EXT_ATTR5, le.D_EXT_ATTR6, le.D_EXT_ATTR7, le.D_EXT_ATTR8, le.D_EXT_ATTR9, le.D_EXT_ATTR10, le.UDA_TEMPLATE_ID FROM po_lines_all_ext_b le , po_lines_draft_all ld WHERE le.po_line_id = ld.po_line_id AND le.draft_id = ld.draft_id UNION ALL SELECT le.po_line_id, le.draft_id , le.EXTENSION_ID, le.ATTR_GROUP_ID, le.DATA_LEVEL_ID, le.PK1_VALUE, le.PK2_VALUE, le.PK3_VALUE, le.PK4_VALUE, le.PK5_VALUE, le.LAST_UPDATE_DATE, le.LAST_UPDATED_BY, le.LAST_UPDATE_LOGIN, le.CREATED_BY, le.CREATION_DATE, le.C_EXT_ATTR1, le.C_EXT_ATTR2, le.C_EXT_ATTR3, le.C_EXT_ATTR4, le.C_EXT_ATTR5, le.C_EXT_ATTR6, le.C_EXT_ATTR7, le.C_EXT_ATTR8, le.C_EXT_ATTR9, le.C_EXT_ATTR10, le.C_EXT_ATTR11, le.C_EXT_ATTR12, le.C_EXT_ATTR13, le.C_EXT_ATTR14, le.C_EXT_ATTR15, le.C_EXT_ATTR16, le.C_EXT_ATTR17, le.C_EXT_ATTR18, le.C_EXT_ATTR19, le.C_EXT_ATTR20, le.C_EXT_ATTR21, le.C_EXT_ATTR22, le.C_EXT_ATTR23, le.C_EXT_ATTR24, le.C_EXT_ATTR25, le.C_EXT_ATTR26, le.C_EXT_ATTR27, le.C_EXT_ATTR28, le.C_EXT_ATTR29, le.C_EXT_ATTR30, le.C_EXT_ATTR31, le.C_EXT_ATTR32, le.C_EXT_ATTR33, le.C_EXT_ATTR34, le.C_EXT_ATTR35, le.C_EXT_ATTR36, le.C_EXT_ATTR37, le.C_EXT_ATTR38, le.C_EXT_ATTR39, le.C_EXT_ATTR40, le.N_EXT_ATTR1, le.N_EXT_ATTR2, le.N_EXT_ATTR3, le.N_EXT_ATTR4, le.N_EXT_ATTR5, le.N_EXT_ATTR6, le.N_EXT_ATTR7, le.N_EXT_ATTR8, le.N_EXT_ATTR9, le.N_EXT_ATTR10, le.N_EXT_ATTR11, le.N_EXT_ATTR12, le.N_EXT_ATTR13, le.N_EXT_ATTR14, le.N_EXT_ATTR15, le.N_EXT_ATTR16, le.N_EXT_ATTR17, le.N_EXT_ATTR18, le.N_EXT_ATTR19, le.N_EXT_ATTR20, le.UOM_EXT_ATTR1, le.UOM_EXT_ATTR2, le.UOM_EXT_ATTR3, le.UOM_EXT_ATTR4, le.UOM_EXT_ATTR5, le.UOM_EXT_ATTR6, le.UOM_EXT_ATTR7, le.UOM_EXT_ATTR8, le.UOM_EXT_ATTR9, le.UOM_EXT_ATTR10, le.UOM_EXT_ATTR11, le.UOM_EXT_ATTR12, le.UOM_EXT_ATTR13, le.UOM_EXT_ATTR14, le.UOM_EXT_ATTR15, le.UOM_EXT_ATTR16, le.UOM_EXT_ATTR17, le.UOM_EXT_ATTR18, le.UOM_EXT_ATTR19, le.UOM_EXT_ATTR20, le.D_EXT_ATTR1, le.D_EXT_ATTR2, le.D_EXT_ATTR3, le.D_EXT_ATTR4, le.D_EXT_ATTR5, le.D_EXT_ATTR6, le.D_EXT_ATTR7, le.D_EXT_ATTR8, le.D_EXT_ATTR9, le.D_EXT_ATTR10, le.UDA_TEMPLATE_ID FROM po_lines_all_ext_b le WHERE le.draft_id = -1 UNION ALL SELECT le.po_line_id, dft.draft_id , le.EXTENSION_ID, le.ATTR_GROUP_ID, le.DATA_LEVEL_ID, le.PK1_VALUE, le.PK2_VALUE, le.PK3_VALUE, le.PK4_VALUE, le.PK5_VALUE, le.LAST_UPDATE_DATE, le.LAST_UPDATED_BY, le.LAST_UPDATE_LOGIN, le.CREATED_BY, le.CREATION_DATE, le.C_EXT_ATTR1, le.C_EXT_ATTR2, le.C_EXT_ATTR3, le.C_EXT_ATTR4, le.C_EXT_ATTR5, le.C_EXT_ATTR6, le.C_EXT_ATTR7, le.C_EXT_ATTR8, le.C_EXT_ATTR9, le.C_EXT_ATTR10, le.C_EXT_ATTR11, le.C_EXT_ATTR12, le.C_EXT_ATTR13, le.C_EXT_ATTR14, le.C_EXT_ATTR15, le.C_EXT_ATTR16, le.C_EXT_ATTR17, le.C_EXT_ATTR18, le.C_EXT_ATTR19, le.C_EXT_ATTR20, le.C_EXT_ATTR21, le.C_EXT_ATTR22, le.C_EXT_ATTR23, le.C_EXT_ATTR24, le.C_EXT_ATTR25, le.C_EXT_ATTR26, le.C_EXT_ATTR27, le.C_EXT_ATTR28, le.C_EXT_ATTR29, le.C_EXT_ATTR30, le.C_EXT_ATTR31, le.C_EXT_ATTR32, le.C_EXT_ATTR33, le.C_EXT_ATTR34, le.C_EXT_ATTR35, le.C_EXT_ATTR36, le.C_EXT_ATTR37, le.C_EXT_ATTR38, le.C_EXT_ATTR39, le.C_EXT_ATTR40, le.N_EXT_ATTR1, le.N_EXT_ATTR2, le.N_EXT_ATTR3, le.N_EXT_ATTR4, le.N_EXT_ATTR5, le.N_EXT_ATTR6, le.N_EXT_ATTR7, le.N_EXT_ATTR8, le.N_EXT_ATTR9, le.N_EXT_ATTR10, le.N_EXT_ATTR11, le.N_EXT_ATTR12, le.N_EXT_ATTR13, le.N_EXT_ATTR14, le.N_EXT_ATTR15, le.N_EXT_ATTR16, le.N_EXT_ATTR17, le.N_EXT_ATTR18, le.N_EXT_ATTR19, le.N_EXT_ATTR20, le.UOM_EXT_ATTR1, le.UOM_EXT_ATTR2, le.UOM_EXT_ATTR3, le.UOM_EXT_ATTR4, le.UOM_EXT_ATTR5, le.UOM_EXT_ATTR6, le.UOM_EXT_ATTR7, le.UOM_EXT_ATTR8, le.UOM_EXT_ATTR9, le.UOM_EXT_ATTR10, le.UOM_EXT_ATTR11, le.UOM_EXT_ATTR12, le.UOM_EXT_ATTR13, le.UOM_EXT_ATTR14, le.UOM_EXT_ATTR15, le.UOM_EXT_ATTR16, le.UOM_EXT_ATTR17, le.UOM_EXT_ATTR18, le.UOM_EXT_ATTR19, le.UOM_EXT_ATTR20, le.D_EXT_ATTR1, le.D_EXT_ATTR2, le.D_EXT_ATTR3, le.D_EXT_ATTR4, le.D_EXT_ATTR5, le.D_EXT_ATTR6, le.D_EXT_ATTR7, le.D_EXT_ATTR8, le.D_EXT_ATTR9, le.D_EXT_ATTR10, le.UDA_TEMPLATE_ID FROM po_lines_all_ext_b le, po_drafts dft, po_lines_all l WHERE le.draft_id = -1 AND l.po_line_id = le.po_line_id AND dft.document_id = l.po_header_id AND NOT EXISTS (SELECT 1 FROM po_lines_all_ext_b ld WHERE ld.po_line_id = le.po_line_id AND ld.draft_id = dft.draft_id AND ld.attr_group_id = le.attr_group_id ) )

View Text - HTML Formatted

SELECT PO_LINE_ID
, DRAFT_ID
, EXTENSION_ID
, ATTR_GROUP_ID
, DATA_LEVEL_ID
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 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
, C_EXT_ATTR14
, C_EXT_ATTR15
, C_EXT_ATTR16
, C_EXT_ATTR17
, C_EXT_ATTR18
, C_EXT_ATTR19
, C_EXT_ATTR20
, C_EXT_ATTR21
, C_EXT_ATTR22
, C_EXT_ATTR23
, C_EXT_ATTR24
, C_EXT_ATTR25
, C_EXT_ATTR26
, C_EXT_ATTR27
, C_EXT_ATTR28
, C_EXT_ATTR29
, C_EXT_ATTR30
, C_EXT_ATTR31
, C_EXT_ATTR32
, C_EXT_ATTR33
, C_EXT_ATTR34
, C_EXT_ATTR35
, C_EXT_ATTR36
, C_EXT_ATTR37
, C_EXT_ATTR38
, C_EXT_ATTR39
, C_EXT_ATTR40
, N_EXT_ATTR1
, N_EXT_ATTR2
, N_EXT_ATTR3
, N_EXT_ATTR4
, N_EXT_ATTR5
, N_EXT_ATTR6
, N_EXT_ATTR7
, N_EXT_ATTR8
, N_EXT_ATTR9
, N_EXT_ATTR10
, N_EXT_ATTR11
, N_EXT_ATTR12
, N_EXT_ATTR13
, N_EXT_ATTR14
, N_EXT_ATTR15
, N_EXT_ATTR16
, N_EXT_ATTR17
, N_EXT_ATTR18
, N_EXT_ATTR19
, N_EXT_ATTR20
, UOM_EXT_ATTR1
, UOM_EXT_ATTR2
, UOM_EXT_ATTR3
, UOM_EXT_ATTR4
, UOM_EXT_ATTR5
, UOM_EXT_ATTR6
, UOM_EXT_ATTR7
, UOM_EXT_ATTR8
, UOM_EXT_ATTR9
, UOM_EXT_ATTR10
, UOM_EXT_ATTR11
, UOM_EXT_ATTR12
, UOM_EXT_ATTR13
, UOM_EXT_ATTR14
, UOM_EXT_ATTR15
, UOM_EXT_ATTR16
, UOM_EXT_ATTR17
, UOM_EXT_ATTR18
, UOM_EXT_ATTR19
, UOM_EXT_ATTR20
, D_EXT_ATTR1
, D_EXT_ATTR2
, D_EXT_ATTR3
, D_EXT_ATTR4
, D_EXT_ATTR5
, D_EXT_ATTR6
, D_EXT_ATTR7
, D_EXT_ATTR8
, D_EXT_ATTR9
, D_EXT_ATTR10
, UDA_TEMPLATE_ID
FROM ( SELECT LE.PO_LINE_ID
, LE.DRAFT_ID
, LE.EXTENSION_ID
, LE.ATTR_GROUP_ID
, LE.DATA_LEVEL_ID
, LE.PK1_VALUE
, LE.PK2_VALUE
, LE.PK3_VALUE
, LE.PK4_VALUE
, LE.PK5_VALUE
, LE.LAST_UPDATE_DATE
, LE.LAST_UPDATED_BY
, LE.LAST_UPDATE_LOGIN
, LE.CREATED_BY
, LE.CREATION_DATE
, LE.C_EXT_ATTR1
, LE.C_EXT_ATTR2
, LE.C_EXT_ATTR3
, LE.C_EXT_ATTR4
, LE.C_EXT_ATTR5
, LE.C_EXT_ATTR6
, LE.C_EXT_ATTR7
, LE.C_EXT_ATTR8
, LE.C_EXT_ATTR9
, LE.C_EXT_ATTR10
, LE.C_EXT_ATTR11
, LE.C_EXT_ATTR12
, LE.C_EXT_ATTR13
, LE.C_EXT_ATTR14
, LE.C_EXT_ATTR15
, LE.C_EXT_ATTR16
, LE.C_EXT_ATTR17
, LE.C_EXT_ATTR18
, LE.C_EXT_ATTR19
, LE.C_EXT_ATTR20
, LE.C_EXT_ATTR21
, LE.C_EXT_ATTR22
, LE.C_EXT_ATTR23
, LE.C_EXT_ATTR24
, LE.C_EXT_ATTR25
, LE.C_EXT_ATTR26
, LE.C_EXT_ATTR27
, LE.C_EXT_ATTR28
, LE.C_EXT_ATTR29
, LE.C_EXT_ATTR30
, LE.C_EXT_ATTR31
, LE.C_EXT_ATTR32
, LE.C_EXT_ATTR33
, LE.C_EXT_ATTR34
, LE.C_EXT_ATTR35
, LE.C_EXT_ATTR36
, LE.C_EXT_ATTR37
, LE.C_EXT_ATTR38
, LE.C_EXT_ATTR39
, LE.C_EXT_ATTR40
, LE.N_EXT_ATTR1
, LE.N_EXT_ATTR2
, LE.N_EXT_ATTR3
, LE.N_EXT_ATTR4
, LE.N_EXT_ATTR5
, LE.N_EXT_ATTR6
, LE.N_EXT_ATTR7
, LE.N_EXT_ATTR8
, LE.N_EXT_ATTR9
, LE.N_EXT_ATTR10
, LE.N_EXT_ATTR11
, LE.N_EXT_ATTR12
, LE.N_EXT_ATTR13
, LE.N_EXT_ATTR14
, LE.N_EXT_ATTR15
, LE.N_EXT_ATTR16
, LE.N_EXT_ATTR17
, LE.N_EXT_ATTR18
, LE.N_EXT_ATTR19
, LE.N_EXT_ATTR20
, LE.UOM_EXT_ATTR1
, LE.UOM_EXT_ATTR2
, LE.UOM_EXT_ATTR3
, LE.UOM_EXT_ATTR4
, LE.UOM_EXT_ATTR5
, LE.UOM_EXT_ATTR6
, LE.UOM_EXT_ATTR7
, LE.UOM_EXT_ATTR8
, LE.UOM_EXT_ATTR9
, LE.UOM_EXT_ATTR10
, LE.UOM_EXT_ATTR11
, LE.UOM_EXT_ATTR12
, LE.UOM_EXT_ATTR13
, LE.UOM_EXT_ATTR14
, LE.UOM_EXT_ATTR15
, LE.UOM_EXT_ATTR16
, LE.UOM_EXT_ATTR17
, LE.UOM_EXT_ATTR18
, LE.UOM_EXT_ATTR19
, LE.UOM_EXT_ATTR20
, LE.D_EXT_ATTR1
, LE.D_EXT_ATTR2
, LE.D_EXT_ATTR3
, LE.D_EXT_ATTR4
, LE.D_EXT_ATTR5
, LE.D_EXT_ATTR6
, LE.D_EXT_ATTR7
, LE.D_EXT_ATTR8
, LE.D_EXT_ATTR9
, LE.D_EXT_ATTR10
, LE.UDA_TEMPLATE_ID
FROM PO_LINES_ALL_EXT_B LE
, PO_LINES_DRAFT_ALL LD
WHERE LE.PO_LINE_ID = LD.PO_LINE_ID
AND LE.DRAFT_ID = LD.DRAFT_ID UNION ALL SELECT LE.PO_LINE_ID
, LE.DRAFT_ID
, LE.EXTENSION_ID
, LE.ATTR_GROUP_ID
, LE.DATA_LEVEL_ID
, LE.PK1_VALUE
, LE.PK2_VALUE
, LE.PK3_VALUE
, LE.PK4_VALUE
, LE.PK5_VALUE
, LE.LAST_UPDATE_DATE
, LE.LAST_UPDATED_BY
, LE.LAST_UPDATE_LOGIN
, LE.CREATED_BY
, LE.CREATION_DATE
, LE.C_EXT_ATTR1
, LE.C_EXT_ATTR2
, LE.C_EXT_ATTR3
, LE.C_EXT_ATTR4
, LE.C_EXT_ATTR5
, LE.C_EXT_ATTR6
, LE.C_EXT_ATTR7
, LE.C_EXT_ATTR8
, LE.C_EXT_ATTR9
, LE.C_EXT_ATTR10
, LE.C_EXT_ATTR11
, LE.C_EXT_ATTR12
, LE.C_EXT_ATTR13
, LE.C_EXT_ATTR14
, LE.C_EXT_ATTR15
, LE.C_EXT_ATTR16
, LE.C_EXT_ATTR17
, LE.C_EXT_ATTR18
, LE.C_EXT_ATTR19
, LE.C_EXT_ATTR20
, LE.C_EXT_ATTR21
, LE.C_EXT_ATTR22
, LE.C_EXT_ATTR23
, LE.C_EXT_ATTR24
, LE.C_EXT_ATTR25
, LE.C_EXT_ATTR26
, LE.C_EXT_ATTR27
, LE.C_EXT_ATTR28
, LE.C_EXT_ATTR29
, LE.C_EXT_ATTR30
, LE.C_EXT_ATTR31
, LE.C_EXT_ATTR32
, LE.C_EXT_ATTR33
, LE.C_EXT_ATTR34
, LE.C_EXT_ATTR35
, LE.C_EXT_ATTR36
, LE.C_EXT_ATTR37
, LE.C_EXT_ATTR38
, LE.C_EXT_ATTR39
, LE.C_EXT_ATTR40
, LE.N_EXT_ATTR1
, LE.N_EXT_ATTR2
, LE.N_EXT_ATTR3
, LE.N_EXT_ATTR4
, LE.N_EXT_ATTR5
, LE.N_EXT_ATTR6
, LE.N_EXT_ATTR7
, LE.N_EXT_ATTR8
, LE.N_EXT_ATTR9
, LE.N_EXT_ATTR10
, LE.N_EXT_ATTR11
, LE.N_EXT_ATTR12
, LE.N_EXT_ATTR13
, LE.N_EXT_ATTR14
, LE.N_EXT_ATTR15
, LE.N_EXT_ATTR16
, LE.N_EXT_ATTR17
, LE.N_EXT_ATTR18
, LE.N_EXT_ATTR19
, LE.N_EXT_ATTR20
, LE.UOM_EXT_ATTR1
, LE.UOM_EXT_ATTR2
, LE.UOM_EXT_ATTR3
, LE.UOM_EXT_ATTR4
, LE.UOM_EXT_ATTR5
, LE.UOM_EXT_ATTR6
, LE.UOM_EXT_ATTR7
, LE.UOM_EXT_ATTR8
, LE.UOM_EXT_ATTR9
, LE.UOM_EXT_ATTR10
, LE.UOM_EXT_ATTR11
, LE.UOM_EXT_ATTR12
, LE.UOM_EXT_ATTR13
, LE.UOM_EXT_ATTR14
, LE.UOM_EXT_ATTR15
, LE.UOM_EXT_ATTR16
, LE.UOM_EXT_ATTR17
, LE.UOM_EXT_ATTR18
, LE.UOM_EXT_ATTR19
, LE.UOM_EXT_ATTR20
, LE.D_EXT_ATTR1
, LE.D_EXT_ATTR2
, LE.D_EXT_ATTR3
, LE.D_EXT_ATTR4
, LE.D_EXT_ATTR5
, LE.D_EXT_ATTR6
, LE.D_EXT_ATTR7
, LE.D_EXT_ATTR8
, LE.D_EXT_ATTR9
, LE.D_EXT_ATTR10
, LE.UDA_TEMPLATE_ID
FROM PO_LINES_ALL_EXT_B LE
WHERE LE.DRAFT_ID = -1 UNION ALL SELECT LE.PO_LINE_ID
, DFT.DRAFT_ID
, LE.EXTENSION_ID
, LE.ATTR_GROUP_ID
, LE.DATA_LEVEL_ID
, LE.PK1_VALUE
, LE.PK2_VALUE
, LE.PK3_VALUE
, LE.PK4_VALUE
, LE.PK5_VALUE
, LE.LAST_UPDATE_DATE
, LE.LAST_UPDATED_BY
, LE.LAST_UPDATE_LOGIN
, LE.CREATED_BY
, LE.CREATION_DATE
, LE.C_EXT_ATTR1
, LE.C_EXT_ATTR2
, LE.C_EXT_ATTR3
, LE.C_EXT_ATTR4
, LE.C_EXT_ATTR5
, LE.C_EXT_ATTR6
, LE.C_EXT_ATTR7
, LE.C_EXT_ATTR8
, LE.C_EXT_ATTR9
, LE.C_EXT_ATTR10
, LE.C_EXT_ATTR11
, LE.C_EXT_ATTR12
, LE.C_EXT_ATTR13
, LE.C_EXT_ATTR14
, LE.C_EXT_ATTR15
, LE.C_EXT_ATTR16
, LE.C_EXT_ATTR17
, LE.C_EXT_ATTR18
, LE.C_EXT_ATTR19
, LE.C_EXT_ATTR20
, LE.C_EXT_ATTR21
, LE.C_EXT_ATTR22
, LE.C_EXT_ATTR23
, LE.C_EXT_ATTR24
, LE.C_EXT_ATTR25
, LE.C_EXT_ATTR26
, LE.C_EXT_ATTR27
, LE.C_EXT_ATTR28
, LE.C_EXT_ATTR29
, LE.C_EXT_ATTR30
, LE.C_EXT_ATTR31
, LE.C_EXT_ATTR32
, LE.C_EXT_ATTR33
, LE.C_EXT_ATTR34
, LE.C_EXT_ATTR35
, LE.C_EXT_ATTR36
, LE.C_EXT_ATTR37
, LE.C_EXT_ATTR38
, LE.C_EXT_ATTR39
, LE.C_EXT_ATTR40
, LE.N_EXT_ATTR1
, LE.N_EXT_ATTR2
, LE.N_EXT_ATTR3
, LE.N_EXT_ATTR4
, LE.N_EXT_ATTR5
, LE.N_EXT_ATTR6
, LE.N_EXT_ATTR7
, LE.N_EXT_ATTR8
, LE.N_EXT_ATTR9
, LE.N_EXT_ATTR10
, LE.N_EXT_ATTR11
, LE.N_EXT_ATTR12
, LE.N_EXT_ATTR13
, LE.N_EXT_ATTR14
, LE.N_EXT_ATTR15
, LE.N_EXT_ATTR16
, LE.N_EXT_ATTR17
, LE.N_EXT_ATTR18
, LE.N_EXT_ATTR19
, LE.N_EXT_ATTR20
, LE.UOM_EXT_ATTR1
, LE.UOM_EXT_ATTR2
, LE.UOM_EXT_ATTR3
, LE.UOM_EXT_ATTR4
, LE.UOM_EXT_ATTR5
, LE.UOM_EXT_ATTR6
, LE.UOM_EXT_ATTR7
, LE.UOM_EXT_ATTR8
, LE.UOM_EXT_ATTR9
, LE.UOM_EXT_ATTR10
, LE.UOM_EXT_ATTR11
, LE.UOM_EXT_ATTR12
, LE.UOM_EXT_ATTR13
, LE.UOM_EXT_ATTR14
, LE.UOM_EXT_ATTR15
, LE.UOM_EXT_ATTR16
, LE.UOM_EXT_ATTR17
, LE.UOM_EXT_ATTR18
, LE.UOM_EXT_ATTR19
, LE.UOM_EXT_ATTR20
, LE.D_EXT_ATTR1
, LE.D_EXT_ATTR2
, LE.D_EXT_ATTR3
, LE.D_EXT_ATTR4
, LE.D_EXT_ATTR5
, LE.D_EXT_ATTR6
, LE.D_EXT_ATTR7
, LE.D_EXT_ATTR8
, LE.D_EXT_ATTR9
, LE.D_EXT_ATTR10
, LE.UDA_TEMPLATE_ID
FROM PO_LINES_ALL_EXT_B LE
, PO_DRAFTS DFT
, PO_LINES_ALL L
WHERE LE.DRAFT_ID = -1
AND L.PO_LINE_ID = LE.PO_LINE_ID
AND DFT.DOCUMENT_ID = L.PO_HEADER_ID
AND NOT EXISTS (SELECT 1
FROM PO_LINES_ALL_EXT_B LD
WHERE LD.PO_LINE_ID = LE.PO_LINE_ID
AND LD.DRAFT_ID = DFT.DRAFT_ID
AND LD.ATTR_GROUP_ID = LE.ATTR_GROUP_ID ) )