eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRPFV_REPLENISHMENT_DSTNS

Source

View Text - Preformatted


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 , substrb(PARTY.PARTY_NAME, 1, 50) CUSTOMER_NAME , LOC.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) , ACCT_SITE.CUST_ACCT_SITE_ID , SR.LAST_UPDATE_DATE , SR.LAST_UPDATED_BY , SR.CREATION_DATE , SR.CREATED_BY FROM HZ_PARTY_SITES PARTY_SITE ,HZ_LOCATIONS LOC ,HZ_CUST_ACCT_SITES_ALL ACCT_SITE ,HZ_CUST_SITE_USES_ALL SITE ,HZ_PARTIES PARTY ,HZ_CUST_ACCOUNTS CUST_ACCT ,HR_ORGANIZATION_INFORMATION HR ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_PARAMETERS PARA ,MRP_SOURCING_RULES SO ,MRP_SR_RECEIPT_ORG SR WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+) AND 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_ACCT.CUST_ACCOUNT_ID(+) AND HR.ORG_INFORMATION2 = SITE.SITE_USE_ID(+) AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+) AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1 ,1), ' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),-99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99) AND '_SEC:RECEIPT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, LOC.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)
, ACCT_SITE.CUST_ACCT_SITE_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_CUST_SITE_USES_ALL SITE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HR_ORGANIZATION_INFORMATION HR
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PARA
, MRP_SOURCING_RULES SO
, MRP_SR_RECEIPT_ORG SR
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND 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_ACCT.CUST_ACCOUNT_ID(+)
AND HR.ORG_INFORMATION2 = SITE.SITE_USE_ID(+)
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID
AND NVL(ACCT_SITE.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND '_SEC:RECEIPT_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY