VIEW: APPS.CSD_REPAIR_TYPES_VL

Source

View Text - Preformatted

SELECT b.rowid, b.repair_type_id, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login, b.workflow_item_type, wf.display_name, b.start_date_active, b.end_date_active, b.attribute_category, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.attribute11, b.attribute12, b.attribute13, b.attribute14, b.attribute15, t.description, t.name, b.auto_process_rma, b.interface_to_om_flag, b.book_sales_order_flag, b.release_sales_order_flag, b.ship_sales_order_flag, b.repair_type_ref, b.repair_mode, b.seeded_flag, b.object_version_number, b.business_process_id, b.price_list_header_id, b.cps_txn_billing_type_id, b.cpr_txn_billing_type_id, b.ls_txn_billing_type_id, b.lr_txn_billing_type_id, b.mtl_txn_billing_type_id, b.lbr_txn_billing_type_id, b.exp_txn_billing_type_id, b.internal_order_flag, b.start_flow_status_id start_flow_status_id, fs_lkup.lookup_code start_flow_status_code, fs_lkup.meaning start_flow_status_meaning, b.third_rma_txn_billing_type_id, b.third_ship_txn_billing_type_id, b.third_party_flag from csd_repair_types_tl t, csd_repair_types_b b, wf_item_types_vl wf, csd_flow_statuses_b fs_b, fnd_lookups fs_lkup WHERE b.repair_type_id = t.repair_type_id and t.language = userenv('LANG') and b.workflow_item_type = wf.name(+) and fs_b.flow_status_id(+) = b.start_flow_status_id and fs_lkup.lookup_type(+) = 'CSD_REPAIR_FLOW_STATUS' and fs_lkup.lookup_code(+) = fs_b.flow_status_code

View Text - HTML Formatted

SELECT B.ROWID
, B.REPAIR_TYPE_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.WORKFLOW_ITEM_TYPE
, WF.DISPLAY_NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, T.DESCRIPTION
, T.NAME
, B.AUTO_PROCESS_RMA
, B.INTERFACE_TO_OM_FLAG
, B.BOOK_SALES_ORDER_FLAG
, B.RELEASE_SALES_ORDER_FLAG
, B.SHIP_SALES_ORDER_FLAG
, B.REPAIR_TYPE_REF
, B.REPAIR_MODE
, B.SEEDED_FLAG
, B.OBJECT_VERSION_NUMBER
, B.BUSINESS_PROCESS_ID
, B.PRICE_LIST_HEADER_ID
, B.CPS_TXN_BILLING_TYPE_ID
, B.CPR_TXN_BILLING_TYPE_ID
, B.LS_TXN_BILLING_TYPE_ID
, B.LR_TXN_BILLING_TYPE_ID
, B.MTL_TXN_BILLING_TYPE_ID
, B.LBR_TXN_BILLING_TYPE_ID
, B.EXP_TXN_BILLING_TYPE_ID
, B.INTERNAL_ORDER_FLAG
, B.START_FLOW_STATUS_ID START_FLOW_STATUS_ID
, FS_LKUP.LOOKUP_CODE START_FLOW_STATUS_CODE
, FS_LKUP.MEANING START_FLOW_STATUS_MEANING
, B.THIRD_RMA_TXN_BILLING_TYPE_ID
, B.THIRD_SHIP_TXN_BILLING_TYPE_ID
, B.THIRD_PARTY_FLAG
FROM CSD_REPAIR_TYPES_TL T
, CSD_REPAIR_TYPES_B B
, WF_ITEM_TYPES_VL WF
, CSD_FLOW_STATUSES_B FS_B
, FND_LOOKUPS FS_LKUP
WHERE B.REPAIR_TYPE_ID = T.REPAIR_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.WORKFLOW_ITEM_TYPE = WF.NAME(+)
AND FS_B.FLOW_STATUS_ID(+) = B.START_FLOW_STATUS_ID
AND FS_LKUP.LOOKUP_TYPE(+) = 'CSD_REPAIR_FLOW_STATUS'
AND FS_LKUP.LOOKUP_CODE(+) = FS_B.FLOW_STATUS_CODE