View: MSC_SUPPLIER_FLEX_FENCES_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SUPPLIER_FLEX_FENCES_V

View Text

SELECT MSC.ROWID
, MSC.TRANSACTION_ID
, MSC.PARENT_ID
, MSC.PLAN_ID
, MSC.SUPPLIER_ID
, MTP.PARTNER_NAME
, MSC.SUPPLIER_SITE_ID
, MTPS.TP_SITE_CODE
, MSC.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, MSC.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSC.FENCE_DAYS
, MSC.SR_INSTANCE_ID
, MSC.TOLERANCE_PERCENTAGE
, MSC.USING_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(MSC.USING_ORGANIZATION_ID
, MSC.SR_INSTANCE_ID)
, MSC.STATUS
, MSC.APPLIED
, MSC.LAST_UPDATE_DATE
, MSC.LAST_UPDATED_BY
, MSC.CREATION_DATE
, MSC.CREATED_BY
, MSC.LAST_UPDATE_LOGIN
, MSC.COLLECTED_FLAG
FROM MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNER_SITES MTPS
, MSC_SYSTEM_ITEMS MSI
, MSC_SUPPLIER_FLEX_FENCES MSC
WHERE MTP.PARTNER_ID = MSC.SUPPLIER_ID
AND MTP.PARTNER_TYPE = 1
AND MTPS.PARTNER_ID(+) = MSC.SUPPLIER_ID
AND MTPS.PARTNER_SITE_ID(+) = MSC.SUPPLIER_SITE_ID
AND MSI.INVENTORY_ITEM_ID = MSC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MSC.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MSC.SR_INSTANCE_ID
AND MSI.PLAN_ID = MSC.PLAN_ID

Columns