View: MSC_SC_BILL_V

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

View Text

SELECT SEGS.ITEM_NAME || '/' || PT.ORGANIZATION_CODE
, SETS.ASSIGNMENT_SET_ID
, SEGS.INVENTORY_ITEM_ID
, SEGS.ITEM_NAME
, PT.SR_TP_ID
, PT.SR_INSTANCE_ID
, PT.ORGANIZATION_CODE
, CAL.CALENDAR_DATE
FROM MSC_ASSIGNMENT_SETS SETS
, MSC_CALENDAR_DATES CAL
, MSC_SYSTEM_ITEMS SEGS
, MSC_TRADING_PARTNERS PT
WHERE CAL.CALENDAR_CODE = PT.CALENDAR_CODE
AND CAL.EXCEPTION_SET_ID = PT.CALENDAR_EXCEPTION_SET_ID
AND CAL.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
AND SEGS.PLAN_ID = -1
AND SEGS.ORGANIZATION_ID = PT.SR_TP_ID
AND SEGS.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
AND PT.PARTNER_TYPE = 3

Columns