Sourcing Rules setup

Sourcing Rules
—————-

SELECT msr.SOURCING_RULE_NAME “Name”
, msr.DESCRIPTION “Description”
, mp.ORGANIZATION_CODE “ORG Code”
, DECODE(msr.PLANNING_ACTIVE
, 1, ‘Y’
, 2, ‘N’) “Planning Active”
, ” “[Effective Dates]”
, msrov.EFFECTIVE_DATE “From Date”
, msrov.DISABLE_DATE “To Date”
, ” “[Shipping Organization]”
, DECODE(mssov.SOURCE_TYPE
, 3, ‘Buy From’
, ‘Transfer From’) “Type”
, mssov.SOURCE_ORGANIZATION_CODE “Org”
, mssov.VENDOR_NAME “Supplier”
, mssov.VENDOR_SITE “Site”
, mssov.ALLOCATION_PERCENT “Allocation %”
, mssov.RANK “Rank”
, mssov.SHIP_METHOD “Shipping Method”
, mssov.INTRANSIT_TIME “Intransit Time”
FROM MRP_SOURCING_RULES msr
, MTL_PARAMETERS mp
, MRP_SR_RECEIPT_ORG_V msrov
, MRP_SR_SOURCE_ORG_V mssov
WHERE msr.ORGANIZATION_ID = mp.ORGANIZATION_ID (+)
AND msr.SOURCING_RULE_ID = msrov.SOURCING_RULE_ID (+)
AND msrov.SR_RECEIPT_ID = mssov.SR_RECEIPT_ID (+)
ORDER BY msr.SOURCING_RULE_NAME
, msrov.EFFECTIVE_DATE
, msrov.DISABLE_DATE
, DECODE(mssov.SOURCE_TYPE
, 3, ‘Buy From’
, ‘Transfer From’)
, mssov.SOURCE_ORGANIZATION_CODE
, mssov.VENDOR_NAME
, mssov.VENDOR_SITE
, mssov.ALLOCATION_PERCENT
, mssov.RANK

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: