[Home] [Help]
840: where sr_instance_id = pINSTANCE_ID
841: and organization_id = nvl(pORGANIZATION_ID,organization_id)
842: and plan_id = c_plan_id;
843: CURSOR c3 (c_plan_id number) IS
844: select count(*) from MSC_SUPPLIES ms
845: where ms.plan_id = c_plan_id
846: and ms.sr_instance_id = pINSTANCE_ID
847: and ms.order_type = 5
848: AND nvl(ms.source_supplier_id,ms.supplier_id) is NOT NULL
1383: ||' RELEASE_ERRORS , '
1384: ||' SCHEDULE_COMPRESSION_DAYS , '
1385: ||' NUMBER1 '
1386: ||')'
1387: ||'SELECT /*+ index(ms msc_supplies_n8) leading(ms) */ '
1388: ||' MRP_SCHEDULE_DATES_S.nextval'||v_dblink||' , '
1389: ||' ms.LAST_UPDATE_DATE , '
1390: ||' ms.LAST_UPDATED_BY , '
1391: ||' ms.CREATION_DATE , '
1464: ||' IMPLEMENT_BUILD_SEQUENCE , '
1465: ||' RELEASE_ERRORS , '
1466: ||' SCHEDULE_COMPRESS_DAYS , '
1467: ||' NUMBER1 '
1468: ||' FROM MSC_SUPPLIES ms,'
1469: ||' MSC_TP_ID_LID mtil,'
1470: ||' MSC_TP_SITE_ID_LID mtsil ,'
1471: ||' msc_trading_partners ORG ,'
1472: ||' MSC_SYSTEM_ITEMS msi'
1653: ||' RELEASE_ERRORS , '
1654: ||' SCHEDULE_COMPRESSION_DAYS , '
1655: ||' NUMBER1 '
1656: ||')'
1657: ||'SELECT /*+ index(ms msc_supplies_n8) leading(ms) */'
1658: ||' MRP_SCHEDULE_DATES_S.nextval'||v_dblink||' , '
1659: ||' ms.LAST_UPDATE_DATE , '
1660: ||' ms.LAST_UPDATED_BY , '
1661: ||' ms.CREATION_DATE , '
1733: ||' IMPLEMENT_BUILD_SEQUENCE , '
1734: ||' RELEASE_ERRORS , '
1735: ||' SCHEDULE_COMPRESS_DAYS , '
1736: ||' NUMBER1 '
1737: ||' FROM MSC_SUPPLIES ms,'
1738: ||' MSC_TP_ID_LID mtil,'
1739: ||' MSC_SYSTEM_ITEMS msi'
1740: ||' WHERE ms.plan_id = :PLAN_ID'
1741: ||' AND ms.sr_instance_id = :pINSTANCE_ID'
1997: ||' IMPLEMENT_BUILD_SEQUENCE , '
1998: ||' RELEASE_ERRORS , '
1999: ||' SCHEDULE_COMPRESS_DAYS , '
2000: ||' NUMBER1 '
2001: ||' FROM MSC_SUPPLIES ms,'
2002: ||' MSC_SYSTEM_ITEMS msi'
2003: ||' WHERE ms.plan_id = :PLAN_ID'
2004: ||' AND ms.sr_instance_id = :pINSTANCE_ID'
2005: ||' AND msi.organization_id = ms.organization_id'