VIEW: APPS.EDW_POA_LN_TYPE_LCV

Source

View Text - Preformatted

SELECT plt.line_type line_type_pk, plt.last_update_date last_update_date, plt.creation_date creation_date, plt.line_type line_type_dp, plt.line_type name, eli.instance_code instance, plt.description description, plt.order_type_lookup_code order_type, NVL(plt.outside_operation_flag, 'N') outside_op_flag, plt.inactive_date inactive_date, plt.attribute_category PLTDR_CONTEXT, plt.attribute1 user_attribute1, plt.attribute2 user_attribute2, plt.attribute3 user_attribute3, plt.attribute4 user_attribute4, plt.attribute5 user_attribute5 FROM po_line_types plt, edw_local_instance eli

View Text - HTML Formatted

SELECT PLT.LINE_TYPE LINE_TYPE_PK
, PLT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PLT.CREATION_DATE CREATION_DATE
, PLT.LINE_TYPE LINE_TYPE_DP
, PLT.LINE_TYPE NAME
, ELI.INSTANCE_CODE INSTANCE
, PLT.DESCRIPTION DESCRIPTION
, PLT.ORDER_TYPE_LOOKUP_CODE ORDER_TYPE
, NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N') OUTSIDE_OP_FLAG
, PLT.INACTIVE_DATE INACTIVE_DATE
, PLT.ATTRIBUTE_CATEGORY PLTDR_CONTEXT
, PLT.ATTRIBUTE1 USER_ATTRIBUTE1
, PLT.ATTRIBUTE2 USER_ATTRIBUTE2
, PLT.ATTRIBUTE3 USER_ATTRIBUTE3
, PLT.ATTRIBUTE4 USER_ATTRIBUTE4
, PLT.ATTRIBUTE5 USER_ATTRIBUTE5
FROM PO_LINE_TYPES PLT
, EDW_LOCAL_INSTANCE ELI