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.MRPBV_REPLENISHMENT_DSTNS

Source

View Text - Preformatted


SELECT DISTINCT SR.EFFECTIVE_DATE , SR.DISABLE_DATE , 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 ,MRP_SOURCING_RULES SO ,MRP_SR_RECEIPT_ORG SR WHERE SR.SOURCING_RULE_ID = SO.SOURCING_RULE_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 CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+) AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+) AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_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:SO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT SR.EFFECTIVE_DATE
, SR.DISABLE_DATE
, 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
, MRP_SOURCING_RULES SO
, MRP_SR_RECEIPT_ORG SR
WHERE SR.SOURCING_RULE_ID = SO.SOURCING_RULE_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 CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_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:SO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY