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_SR_BOD_ASSIGNMENTS

Source

View Text - Preformatted


SELECT LO.MEANING , DECODE(SR.SOURCING_RULE_TYPE,1, SO.SOURCING_RULE_NAME, NULL) , DECODE(SR.SOURCING_RULE_TYPE,2, SO.SOURCING_RULE_NAME, NULL) , DECODE(SR.ASSIGNMENT_TYPE, 1, NULL, 4, PA.ORGANIZATION_CODE, NULL) , DECODE(SR.ASSIGNMENT_TYPE, 1, NULL, 4, AL.NAME, NULL) , substrb(PARTY.PARTY_NAME, 1, 50) , LOC.ADDRESS1 ,'_KF:_EX:NULL' ,'_KF:_EX:NULL' , '_DF:MRP:MRP_SR_ASSIGNMENTS:SR' , SR.ASSIGNMENT_ID , SR.ASSIGNMENT_SET_ID , DECODE(SR.SOURCING_RULE_TYPE, 1, SR.SOURCING_RULE_ID, NULL) , DECODE(SR.SOURCING_RULE_TYPE, 2, SR.SOURCING_RULE_ID, NULL) , SR.ORGANIZATION_ID , SR.CUSTOMER_ID , SR.SHIP_TO_SITE_ID , SR.CATEGORY_ID , SR.CATEGORY_SET_ID , SR.INVENTORY_ITEM_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_PARTIES PARTY ,HZ_CUST_ACCOUNTS CUST_ACCT ,HZ_CUST_SITE_USES_ALL SI ,MFG_LOOKUPS LO ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_PARAMETERS PA ,MRP_SOURCING_RULES SO ,MRP_SR_ASSIGNMENTS SR WHERE SR.ASSIGNMENT_TYPE IN (1,4) AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+) AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+) AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE' AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE AND SR.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND SR.SHIP_TO_SITE_ID = SI.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 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 SI.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) UNION SELECT LO.MEANING ,DECODE(SR.SOURCING_RULE_TYPE,1, SO.SOURCING_RULE_NAME, NULL) ,DECODE(SR.SOURCING_RULE_TYPE,2, SO.SOURCING_RULE_NAME, NULL) ,DECODE(SR.ASSIGNMENT_TYPE, 2, NULL, 5, PA.ORGANIZATION_CODE, NULL) ,DECODE(SR.ASSIGNMENT_TYPE, 2, NULL, 5, AL.NAME, NULL) ,substrb(PARTY.PARTY_NAME, 1, 50) ,LOC.ADDRESS1 ,'_KF:_EX:NULL' ,'_KF:INV:MCAT:CA' ,'_DF:MRP:MRP_SR_ASSIGNMENTS:SR' ,SR.ASSIGNMENT_ID ,SR.ASSIGNMENT_SET_ID ,DECODE(SR.SOURCING_RULE_TYPE, 1, SR.SOURCING_RULE_ID, NULL) ,DECODE(SR.SOURCING_RULE_TYPE, 2, SR.SOURCING_RULE_ID, NULL) ,SR.ORGANIZATION_ID ,SR.CUSTOMER_ID ,SR.SHIP_TO_SITE_ID ,SR.CATEGORY_ID ,SR.CATEGORY_SET_ID ,SR.INVENTORY_ITEM_ID ,SR.LAST_UPDATE_DATE ,SR.LAST_UPDATED_BY ,SR.CREATION_DATE ,SR.CREATED_BY FROM HZ_PARTIES PARTY ,HZ_CUST_ACCOUNTS CUST_ACCT ,HZ_PARTY_SITES PARTY_SITE ,HZ_LOCATIONS LOC ,HZ_CUST_ACCT_SITES_ALL ACCT_SITE ,HZ_CUST_SITE_USES_ALL SI ,MFG_LOOKUPS LO ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_CATEGORY_SETS CAT ,MTL_CATEGORIES CA ,MRP_SOURCING_RULES SO ,MRP_SR_ASSIGNMENTS SR WHERE SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID AND SR.CATEGORY_ID = CA.CATEGORY_ID AND SR.CATEGORY_SET_ID = CAT.CATEGORY_SET_ID AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+) AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+) AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE' AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE AND SR.ASSIGNMENT_TYPE IN (2,5) AND SR.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND SR.SHIP_TO_SITE_ID = SI.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 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 SI.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) UNION SELECT LO.MEANING ,DECODE(SR.SOURCING_RULE_TYPE,1, SO.SOURCING_RULE_NAME, NULL) ,DECODE(SR.SOURCING_RULE_TYPE,2, SO.SOURCING_RULE_NAME, NULL) ,DECODE(SR.ASSIGNMENT_TYPE, 3, NULL, 6, PA.ORGANIZATION_CODE, NULL) ,DECODE(SR.ASSIGNMENT_TYPE, 3, NULL, 6, AL.NAME, NULL) ,substrb(PARTY.PARTY_NAME, 1, 50) ,LOC.ADDRESS1 ,'_KF:INV:MSTK:SY' ,'_KF:_EX:NULL' ,'_DF:MRP:MRP_SR_ASSIGNMENTS:SR' ,SR.ASSIGNMENT_ID ,SR.ASSIGNMENT_SET_ID ,DECODE(SR.SOURCING_RULE_TYPE, 1, SR.SOURCING_RULE_ID, NULL) ,DECODE(SR.SOURCING_RULE_TYPE, 2, SR.SOURCING_RULE_ID, NULL) ,SR.ORGANIZATION_ID ,SR.CUSTOMER_ID ,SR.SHIP_TO_SITE_ID ,SR.CATEGORY_ID ,SR.CATEGORY_SET_ID ,SR.INVENTORY_ITEM_ID ,SR.LAST_UPDATE_DATE ,SR.LAST_UPDATED_BY ,SR.CREATION_DATE ,SR.CREATED_BY FROM HZ_PARTIES PARTY ,HZ_CUST_ACCOUNTS CUST_ACCT ,HZ_PARTY_SITES PARTY_SITE ,HZ_LOCATIONS LOC ,HZ_CUST_ACCT_SITES_ALL ACCT_SITE ,HZ_CUST_SITE_USES_ALL SI ,MFG_LOOKUPS LO ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_SYSTEM_ITEMS SY ,MRP_SOURCING_RULES SO ,MRP_SR_ASSIGNMENTS SR WHERE SR.ASSIGNMENT_TYPE IN (3,6) AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID AND SR.ORGANIZATION_ID = SY.ORGANIZATION_ID(+) AND SR.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID(+) AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+) AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+) AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE' AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE AND SR.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND SR.SHIP_TO_SITE_ID = SI.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 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 SI.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT LO.MEANING
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 1
, NULL
, 4
, PA.ORGANIZATION_CODE
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 1
, NULL
, 4
, AL.NAME
, NULL)
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, LOC.ADDRESS1
, '_KF:_EX:NULL'
, '_KF:_EX:NULL'
, '_DF:MRP:MRP_SR_ASSIGNMENTS:SR'
, SR.ASSIGNMENT_ID
, SR.ASSIGNMENT_SET_ID
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SR.SOURCING_RULE_ID
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SR.SOURCING_RULE_ID
, NULL)
, SR.ORGANIZATION_ID
, SR.CUSTOMER_ID
, SR.SHIP_TO_SITE_ID
, SR.CATEGORY_ID
, SR.CATEGORY_SET_ID
, SR.INVENTORY_ITEM_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_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_SITE_USES_ALL SI
, MFG_LOOKUPS LO
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MRP_SOURCING_RULES SO
, MRP_SR_ASSIGNMENTS SR
WHERE SR.ASSIGNMENT_TYPE IN (1
, 4)
AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE
AND SR.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND SR.SHIP_TO_SITE_ID = SI.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 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 SI.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) UNION SELECT LO.MEANING
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 2
, NULL
, 5
, PA.ORGANIZATION_CODE
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 2
, NULL
, 5
, AL.NAME
, NULL)
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, LOC.ADDRESS1
, '_KF:_EX:NULL'
, '_KF:INV:MCAT:CA'
, '_DF:MRP:MRP_SR_ASSIGNMENTS:SR'
, SR.ASSIGNMENT_ID
, SR.ASSIGNMENT_SET_ID
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SR.SOURCING_RULE_ID
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SR.SOURCING_RULE_ID
, NULL)
, SR.ORGANIZATION_ID
, SR.CUSTOMER_ID
, SR.SHIP_TO_SITE_ID
, SR.CATEGORY_ID
, SR.CATEGORY_SET_ID
, SR.INVENTORY_ITEM_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_CUST_SITE_USES_ALL SI
, MFG_LOOKUPS LO
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_CATEGORY_SETS CAT
, MTL_CATEGORIES CA
, MRP_SOURCING_RULES SO
, MRP_SR_ASSIGNMENTS SR
WHERE SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.CATEGORY_ID = CA.CATEGORY_ID
AND SR.CATEGORY_SET_ID = CAT.CATEGORY_SET_ID
AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE
AND SR.ASSIGNMENT_TYPE IN (2
, 5)
AND SR.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND SR.SHIP_TO_SITE_ID = SI.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 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 SI.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) UNION SELECT LO.MEANING
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SO.SOURCING_RULE_NAME
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 3
, NULL
, 6
, PA.ORGANIZATION_CODE
, NULL)
, DECODE(SR.ASSIGNMENT_TYPE
, 3
, NULL
, 6
, AL.NAME
, NULL)
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, LOC.ADDRESS1
, '_KF:INV:MSTK:SY'
, '_KF:_EX:NULL'
, '_DF:MRP:MRP_SR_ASSIGNMENTS:SR'
, SR.ASSIGNMENT_ID
, SR.ASSIGNMENT_SET_ID
, DECODE(SR.SOURCING_RULE_TYPE
, 1
, SR.SOURCING_RULE_ID
, NULL)
, DECODE(SR.SOURCING_RULE_TYPE
, 2
, SR.SOURCING_RULE_ID
, NULL)
, SR.ORGANIZATION_ID
, SR.CUSTOMER_ID
, SR.SHIP_TO_SITE_ID
, SR.CATEGORY_ID
, SR.CATEGORY_SET_ID
, SR.INVENTORY_ITEM_ID
, SR.LAST_UPDATE_DATE
, SR.LAST_UPDATED_BY
, SR.CREATION_DATE
, SR.CREATED_BY
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_CUST_SITE_USES_ALL SI
, MFG_LOOKUPS LO
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MRP_SOURCING_RULES SO
, MRP_SR_ASSIGNMENTS SR
WHERE SR.ASSIGNMENT_TYPE IN (3
, 6)
AND SR.SOURCING_RULE_ID = SO.SOURCING_RULE_ID
AND SR.ORGANIZATION_ID = SY.ORGANIZATION_ID(+)
AND SR.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID(+)
AND SR.ORGANIZATION_ID = PA.ORGANIZATION_ID(+)
AND SR.ORGANIZATION_ID = AL.ORGANIZATION_ID(+)
AND LO.LOOKUP_TYPE = 'MRP_ASSIGNMENT_TYPE'
AND LO.LOOKUP_CODE = SR.ASSIGNMENT_TYPE
AND SR.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND SR.SHIP_TO_SITE_ID = SI.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 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 SI.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) WITH READ ONLY