DBA Data[Home] [Help]

VIEW: APPS.MSC_PO_RESCHEDULE_HEADER_V

Source

View Text - Preformatted

SELECT distinct mpr. purchase_order_id, mpr.PO_NUMBER, mpr.SR_INSTANCE_ID, mai.INSTANCE_CODE, mpr.source_line_id FROM MSC_PO_RESCHEDULE_INTERFACE mpr, MSC_APPS_INSTANCES mai WHERE mpr.sr_instance_id = mai.instance_id
View Text - HTML Formatted

SELECT DISTINCT MPR. PURCHASE_ORDER_ID
, MPR.PO_NUMBER
, MPR.SR_INSTANCE_ID
, MAI.INSTANCE_CODE
, MPR.SOURCE_LINE_ID
FROM MSC_PO_RESCHEDULE_INTERFACE MPR
, MSC_APPS_INSTANCES MAI
WHERE MPR.SR_INSTANCE_ID = MAI.INSTANCE_ID