View: MTL_CLIENT_PARAMETERS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_CLIENT_PARAMETERS_V

View Text

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)

Columns