VIEW: APPS.MSC_PO_RESCHEDULE_DETAILS_V

Source

View Text - Preformatted

SELECT mpr.source_line_id, mpr.purchase_order_id, mpr.PO_NUMBER, mpr.LINE_ID, s.PURCH_LINE_NUM , s.ORGANIZATION_ID, MSC_ST_UTIL.ret_org_code(mpr.SR_INSTANCE_ID,s.ORGANIZATION_ID) ORG_CODE, MSC_ST_UTIL.ret_partner_name(nvl(s.SUPPLIER_ID, s.source_supplier_id)) SUPPLIER_NAME, nvl(s.SUPPLIER_ID, s.source_supplier_id) supplier_id, MSC_ST_UTIL.ret_partner_site(nvl(s.SUPPLIER_SITE_ID, s.source_supplier_site_id)) supplier_site_code, nvl (s.SUPPLIER_SITE_ID, s.source_supplier_site_id) supplier_site_id, msi.inventory_item_id, msi.ITEM_NAME, mpr.QUANTITY, mpr.UOM, mpr.NEED_BY_DATE, mpr.SR_INSTANCE_ID, mai.INSTANCE_CODE FROM MSC_PO_RESCHEDULE_INTERFACE mpr, MSC_APPS_INSTANCES mai, msc_system_items msi, msc_supplies s WHERE mpr.sr_instance_id = mai.instance_id and mpr.source_line_id = s.transaction_id and mpr.plan_id = s.plan_id and mpr.sr_instance_id = s.sr_instance_id and msi.inventory_item_id = s.inventory_item_id and msi.plan_id = s.plan_id and msi.organization_id = s.organization_id and msi.sr_instance_id = s.sr_instance_id

View Text - HTML Formatted

SELECT MPR.SOURCE_LINE_ID
, MPR.PURCHASE_ORDER_ID
, MPR.PO_NUMBER
, MPR.LINE_ID
, S.PURCH_LINE_NUM
, S.ORGANIZATION_ID
, MSC_ST_UTIL.RET_ORG_CODE(MPR.SR_INSTANCE_ID
, S.ORGANIZATION_ID) ORG_CODE
, MSC_ST_UTIL.RET_PARTNER_NAME(NVL(S.SUPPLIER_ID
, S.SOURCE_SUPPLIER_ID)) SUPPLIER_NAME
, NVL(S.SUPPLIER_ID
, S.SOURCE_SUPPLIER_ID) SUPPLIER_ID
, MSC_ST_UTIL.RET_PARTNER_SITE(NVL(S.SUPPLIER_SITE_ID
, S.SOURCE_SUPPLIER_SITE_ID)) SUPPLIER_SITE_CODE
, NVL (S.SUPPLIER_SITE_ID
, S.SOURCE_SUPPLIER_SITE_ID) SUPPLIER_SITE_ID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MPR.QUANTITY
, MPR.UOM
, MPR.NEED_BY_DATE
, MPR.SR_INSTANCE_ID
, MAI.INSTANCE_CODE
FROM MSC_PO_RESCHEDULE_INTERFACE MPR
, MSC_APPS_INSTANCES MAI
, MSC_SYSTEM_ITEMS MSI
, MSC_SUPPLIES S
WHERE MPR.SR_INSTANCE_ID = MAI.INSTANCE_ID
AND MPR.SOURCE_LINE_ID = S.TRANSACTION_ID
AND MPR.PLAN_ID = S.PLAN_ID
AND MPR.SR_INSTANCE_ID = S.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
AND MSI.PLAN_ID = S.PLAN_ID
AND MSI.ORGANIZATION_ID = S.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = S.SR_INSTANCE_ID