View: MRPFV_REPLENISHMENT_DSTNS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPFV_REPLENISHMENT_DSTNS

View Text

SELECT DECODE(SO.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SO.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, PARA.ORGANIZATION_CODE
, AL.NAME
, CUST.CUSTOMER_NAME
, ADDR.ADDRESS1
, SR.EFFECTIVE_DATE
, SR.DISABLE_DATE
, '_DF:MRP:MRP_SR_RECEIPT_ORG:SR'
, SR.SR_RECEIPT_ID
, DECODE(SO.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_ID
, NULL)
, DECODE(SO.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_ID
, NULL)
, SR.RECEIPT_ORGANIZATION_ID
, TO_NUMBER(HR.ORG_INFORMATION1)
, TO_NUMBER(HR.ORG_INFORMATION2)
, ADDR.ADDRESS_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM RA_ADDRESSES ADDR
, RA_SITE_USES_ALL SITE
, RA_CUSTOMERS CUST
, HR_ORGANIZATION_INFORMATION HR
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PARA
, MRP_SOURCING_RULES SO
, MRP_SR_RECEIPT_ORG SR
WHERE SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.RECEIPT_ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND SR.RECEIPT_ORGANIZATION_ID = AL.ORGANIZATION_ID
AND SR.RECEIPT_ORGANIZATION_ID = HR.ORGANIZATION_ID(+)
AND HR.ORG_INFORMATION_CONTEXT(+) = 'CUSTOMER/SUPPLIER ASSOCIATION'
AND HR.ORG_INFORMATION1 = CUST.CUSTOMER_ID(+)
AND HR.ORG_INFORMATION2 = SITE.SITE_USE_ID(+)
AND SITE.ADDRESS_ID = ADDR.ADDRESS_ID(+)
AND '_SEC:RECEIPT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns