VIEW: APPS.MRPFV_FORECASTS

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , DE.FORECAST_DESIGNATOR FORECAST_NAME , DE.DESCRIPTION DESCRIPTION , DE.FORECAST_SET FORECAST_SET_NAME , DE.DISABLE_DATE END_EFFECTIVE_DATE , DE.DEMAND_CLASS DEMAND_CLASS , substrb(PARTY.PARTY_NAME, 1, 50) CUSTOMER_NAME , CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER , LOC.ADDRESS1 SHIP_ADDRESS , LOC1.ADDRESS1 BILL_ADDRESS , '_DF:MRP:MRPFFCFN2:de' , DE.ORGANIZATION_ID , DE.CUSTOMER_ID , DE.SHIP_ID , DE.BILL_ID , DE.LAST_UPDATE_DATE , DE.LAST_UPDATED_BY , DE.CREATION_DATE , DE.CREATED_BY FROM MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,HZ_PARTIES PARTY ,HZ_CUST_ACCOUNTS CUST_ACCT ,HZ_CUST_SITE_USES_ALL SI1 ,HZ_PARTY_SITES PARTY_SITE ,HZ_LOCATIONS LOC ,HZ_CUST_ACCT_SITES_ALL ACCT_SITE ,HZ_CUST_SITE_USES_ALL SI2 ,HZ_PARTY_SITES PARTY_SITE1 ,HZ_LOCATIONS LOC1 ,HZ_CUST_ACCT_SITES_ALL ACCT_SITE1 ,MRP_FORECAST_DESIGNATORS DE WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+) AND DE.FORECAST_SET IS NOT NULL AND DE.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND DE.BILL_ID = SI1.CUST_ACCT_SITE_ID(+) AND SI1.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 DE.SHIP_ID = SI2.SITE_USE_ID(+) AND ACCT_SITE1.PARTY_SITE_ID = PARTY_SITE1.PARTY_SITE_ID(+) AND LOC1.LOCATION_ID(+) = PARTY_SITE1.LOCATION_ID AND SI2.CUST_ACCT_SITE_ID = ACCT_SITE1.CUST_ACCT_SITE_ID(+) AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, DE.FORECAST_DESIGNATOR FORECAST_NAME
, DE.DESCRIPTION DESCRIPTION
, DE.FORECAST_SET FORECAST_SET_NAME
, DE.DISABLE_DATE END_EFFECTIVE_DATE
, DE.DEMAND_CLASS DEMAND_CLASS
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, LOC.ADDRESS1 SHIP_ADDRESS
, LOC1.ADDRESS1 BILL_ADDRESS
, '_DF:MRP:MRPFFCFN2:DE'
, DE.ORGANIZATION_ID
, DE.CUSTOMER_ID
, DE.SHIP_ID
, DE.BILL_ID
, DE.LAST_UPDATE_DATE
, DE.LAST_UPDATED_BY
, DE.CREATION_DATE
, DE.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_SITE_USES_ALL SI1
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_CUST_SITE_USES_ALL SI2
, HZ_PARTY_SITES PARTY_SITE1
, HZ_LOCATIONS LOC1
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE1
, MRP_FORECAST_DESIGNATORS DE
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND DE.FORECAST_SET IS NOT NULL
AND DE.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND DE.BILL_ID = SI1.CUST_ACCT_SITE_ID(+)
AND SI1.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 DE.SHIP_ID = SI2.SITE_USE_ID(+)
AND ACCT_SITE1.PARTY_SITE_ID = PARTY_SITE1.PARTY_SITE_ID(+)
AND LOC1.LOCATION_ID(+) = PARTY_SITE1.LOCATION_ID
AND SI2.CUST_ACCT_SITE_ID = ACCT_SITE1.CUST_ACCT_SITE_ID(+)
AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY