VIEW: APPS.MSC_SAFETY_STOCKS_V

Source

View Text - Preformatted

SELECT MSS.ROWID ROW_ID, MSI.SR_INVENTORY_ITEM_ID, MSI.INVENTORY_ITEM_ID, MSI.ITEM_NAME, MSI.DESCRIPTION, MSI.UOM_CODE, MSS.ORGANIZATION_ID , MSS.SR_INSTANCE_ID, MSS.PERIOD_START_DATE EFFECTIVITY_DATE, MSS.LAST_UPDATE_DATE, MSS.LAST_UPDATED_BY, MSS.CREATION_DATE, MSS.CREATED_BY, MSS.LAST_UPDATE_LOGIN, MSI.SAFETY_STOCK_CODE, MSS.SAFETY_STOCK_QUANTITY, MSS.REQUEST_ID, MSS.PROGRAM_APPLICATION_ID, MSS.PROGRAM_ID, MSS.PROGRAM_UPDATE_DATE, MSS.PROJECT_ID, MSS.TASK_ID, MSS.PLANNING_GROUP, MSS.PLAN_ID, msc_get_name.task(MSS.TASK_ID, MSS.PROJECT_ID, MSS.ORGANIZATION_ID, MSS.PLAN_ID, MSS.SR_INSTANCE_ID) , msc_get_name.project(MSS.PROJECT_ID, MSS.ORGANIZATION_ID, MSS.PLAN_ID, MSS.SR_INSTANCE_ID) ,msc_get_name.ss_method_text(-1, mss.organization_id, mss.sr_instance_id, mss.inventory_item_id), mss.user_defined_safety_stocks, mss.user_defined_dos, msc_get_name.org_code(mss.organization_id, mss.sr_instance_id) FROM MSC_SAFETY_STOCKS MSS, MSC_SYSTEM_ITEMS MSI WHERE MSS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID AND MSS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MSS.PLAN_ID = MSI.PLAN_ID

View Text - HTML Formatted

SELECT MSS.ROWID ROW_ID
, MSI.SR_INVENTORY_ITEM_ID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.UOM_CODE
, MSS.ORGANIZATION_ID
, MSS.SR_INSTANCE_ID
, MSS.PERIOD_START_DATE EFFECTIVITY_DATE
, MSS.LAST_UPDATE_DATE
, MSS.LAST_UPDATED_BY
, MSS.CREATION_DATE
, MSS.CREATED_BY
, MSS.LAST_UPDATE_LOGIN
, MSI.SAFETY_STOCK_CODE
, MSS.SAFETY_STOCK_QUANTITY
, MSS.REQUEST_ID
, MSS.PROGRAM_APPLICATION_ID
, MSS.PROGRAM_ID
, MSS.PROGRAM_UPDATE_DATE
, MSS.PROJECT_ID
, MSS.TASK_ID
, MSS.PLANNING_GROUP
, MSS.PLAN_ID
, MSC_GET_NAME.TASK(MSS.TASK_ID
, MSS.PROJECT_ID
, MSS.ORGANIZATION_ID
, MSS.PLAN_ID
, MSS.SR_INSTANCE_ID)
, MSC_GET_NAME.PROJECT(MSS.PROJECT_ID
, MSS.ORGANIZATION_ID
, MSS.PLAN_ID
, MSS.SR_INSTANCE_ID)
, MSC_GET_NAME.SS_METHOD_TEXT(-1
, MSS.ORGANIZATION_ID
, MSS.SR_INSTANCE_ID
, MSS.INVENTORY_ITEM_ID)
, MSS.USER_DEFINED_SAFETY_STOCKS
, MSS.USER_DEFINED_DOS
, MSC_GET_NAME.ORG_CODE(MSS.ORGANIZATION_ID
, MSS.SR_INSTANCE_ID)
FROM MSC_SAFETY_STOCKS MSS
, MSC_SYSTEM_ITEMS MSI
WHERE MSS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSS.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSS.PLAN_ID = MSI.PLAN_ID