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.MSC_SC_BILL_V

Source

View Text - Preformatted


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 ,pt.modeled_supplier_id, pt.modeled_supplier_site_id 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

View Text - HTML Formatted

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
, PT.MODELED_SUPPLIER_ID
, PT.MODELED_SUPPLIER_SITE_ID
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