VIEW: APPS.MTL_CLIENT_PARAMETERS_V

Source

View Text - Preformatted

SELECT row_id, client_id , client_code , client_name , client_number, trading_partner_site_id, receipt_asn_exists_code, rma_receipt_routing_id, routing_name, group_by_customer_flag , group_by_freight_terms_flag , group_by_fob_flag, group_by_ship_method_flag , otm_enabled , ship_confirm_rule_id, ship_confirm_rule_name , autocreate_del_orders_flag , delivery_report_set_id, ship_confirm_document_set_name , lpn_prefix , lpn_suffix , ucc_128_suffix_flag , total_lpn_length, lpn_starting_number , attribute_category , attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 , attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14 , attribute15 , last_update_date , last_updated_by , creation_date , created_by, last_update_login FROM (SELECT client_param.ROWID row_id, client_param.client_id , client_param.client_code , parties.party_name client_name , client_param.client_number, client_param.trading_partner_site_id, client_param.receipt_asn_exists_code, client_param.rma_receipt_routing_id, rcv_routing.routing_name, client_param.group_by_customer_flag , client_param.group_by_freight_terms_flag , client_param.group_by_fob_flag, client_param.group_by_ship_method_flag , client_param.otm_enabled , client_param.ship_confirm_rule_id, ship_conf_rule.NAME ship_confirm_rule_name , client_param.autocreate_del_orders_flag , client_param.delivery_report_set_id, report_set.name ship_confirm_document_set_name, client_param.lpn_prefix , client_param.lpn_suffix , client_param.ucc_128_suffix_flag , client_param.total_lpn_length, client_param.lpn_starting_number , client_param.attribute_category , client_param.attribute1 , client_param.attribute2 , client_param.attribute3 , client_param.attribute4 , client_param.attribute5 , client_param.attribute6 , client_param.attribute7 , client_param.attribute8 , client_param.attribute9 , client_param.attribute10 , client_param.attribute11 , client_param.attribute12 , client_param.attribute13 , client_param.attribute14 , client_param.attribute15 , client_param.last_update_date , client_param.last_updated_by , client_param.creation_date , client_param.created_by, client_param.last_update_login FROM mtl_client_parameters client_param, rcv_routing_headers rcv_routing , wsh_ship_confirm_rules ship_conf_rule , wsh_report_sets report_set , hz_parties parties, hz_cust_Accounts cust_account WHERE rcv_routing.routing_header_id(+) = client_param.rma_receipt_routing_id AND ship_conf_rule.ship_confirm_rule_id(+) = client_param.ship_confirm_rule_id AND report_set.report_set_id(+) = client_param.delivery_report_set_id AND parties.party_id = cust_account.party_id AND cust_account.cust_account_id = client_param.client_id)

View Text - HTML Formatted

SELECT ROW_ID
, CLIENT_ID
, CLIENT_CODE
, CLIENT_NAME
, CLIENT_NUMBER
, TRADING_PARTNER_SITE_ID
, RECEIPT_ASN_EXISTS_CODE
, RMA_RECEIPT_ROUTING_ID
, ROUTING_NAME
, GROUP_BY_CUSTOMER_FLAG
, GROUP_BY_FREIGHT_TERMS_FLAG
, GROUP_BY_FOB_FLAG
, GROUP_BY_SHIP_METHOD_FLAG
, OTM_ENABLED
, SHIP_CONFIRM_RULE_ID
, SHIP_CONFIRM_RULE_NAME
, AUTOCREATE_DEL_ORDERS_FLAG
, DELIVERY_REPORT_SET_ID
, SHIP_CONFIRM_DOCUMENT_SET_NAME
, LPN_PREFIX
, LPN_SUFFIX
, UCC_128_SUFFIX_FLAG
, TOTAL_LPN_LENGTH
, LPN_STARTING_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM (SELECT CLIENT_PARAM.ROWID ROW_ID
, CLIENT_PARAM.CLIENT_ID
, CLIENT_PARAM.CLIENT_CODE
, PARTIES.PARTY_NAME CLIENT_NAME
, CLIENT_PARAM.CLIENT_NUMBER
, CLIENT_PARAM.TRADING_PARTNER_SITE_ID
, CLIENT_PARAM.RECEIPT_ASN_EXISTS_CODE
, CLIENT_PARAM.RMA_RECEIPT_ROUTING_ID
, RCV_ROUTING.ROUTING_NAME
, CLIENT_PARAM.GROUP_BY_CUSTOMER_FLAG
, CLIENT_PARAM.GROUP_BY_FREIGHT_TERMS_FLAG
, CLIENT_PARAM.GROUP_BY_FOB_FLAG
, CLIENT_PARAM.GROUP_BY_SHIP_METHOD_FLAG
, CLIENT_PARAM.OTM_ENABLED
, CLIENT_PARAM.SHIP_CONFIRM_RULE_ID
, SHIP_CONF_RULE.NAME SHIP_CONFIRM_RULE_NAME
, CLIENT_PARAM.AUTOCREATE_DEL_ORDERS_FLAG
, CLIENT_PARAM.DELIVERY_REPORT_SET_ID
, REPORT_SET.NAME SHIP_CONFIRM_DOCUMENT_SET_NAME
, CLIENT_PARAM.LPN_PREFIX
, CLIENT_PARAM.LPN_SUFFIX
, CLIENT_PARAM.UCC_128_SUFFIX_FLAG
, CLIENT_PARAM.TOTAL_LPN_LENGTH
, CLIENT_PARAM.LPN_STARTING_NUMBER
, CLIENT_PARAM.ATTRIBUTE_CATEGORY
, CLIENT_PARAM.ATTRIBUTE1
, CLIENT_PARAM.ATTRIBUTE2
, CLIENT_PARAM.ATTRIBUTE3
, CLIENT_PARAM.ATTRIBUTE4
, CLIENT_PARAM.ATTRIBUTE5
, CLIENT_PARAM.ATTRIBUTE6
, CLIENT_PARAM.ATTRIBUTE7
, CLIENT_PARAM.ATTRIBUTE8
, CLIENT_PARAM.ATTRIBUTE9
, CLIENT_PARAM.ATTRIBUTE10
, CLIENT_PARAM.ATTRIBUTE11
, CLIENT_PARAM.ATTRIBUTE12
, CLIENT_PARAM.ATTRIBUTE13
, CLIENT_PARAM.ATTRIBUTE14
, CLIENT_PARAM.ATTRIBUTE15
, CLIENT_PARAM.LAST_UPDATE_DATE
, CLIENT_PARAM.LAST_UPDATED_BY
, CLIENT_PARAM.CREATION_DATE
, CLIENT_PARAM.CREATED_BY
, CLIENT_PARAM.LAST_UPDATE_LOGIN
FROM MTL_CLIENT_PARAMETERS CLIENT_PARAM
, RCV_ROUTING_HEADERS RCV_ROUTING
, WSH_SHIP_CONFIRM_RULES SHIP_CONF_RULE
, WSH_REPORT_SETS REPORT_SET
, HZ_PARTIES PARTIES
, HZ_CUST_ACCOUNTS CUST_ACCOUNT
WHERE RCV_ROUTING.ROUTING_HEADER_ID(+) = CLIENT_PARAM.RMA_RECEIPT_ROUTING_ID
AND SHIP_CONF_RULE.SHIP_CONFIRM_RULE_ID(+) = CLIENT_PARAM.SHIP_CONFIRM_RULE_ID
AND REPORT_SET.REPORT_SET_ID(+) = CLIENT_PARAM.DELIVERY_REPORT_SET_ID
AND PARTIES.PARTY_ID = CUST_ACCOUNT.PARTY_ID
AND CUST_ACCOUNT.CUST_ACCOUNT_ID = CLIENT_PARAM.CLIENT_ID)