[Home] [Help]
1038: last_day(ass_mfp.demand_date) DISABLE_DATE
1039: from
1040: msc_plan_organizations ass_mpo,
1041: msc_system_items ass_msi,
1042: msd_level_values ass_mlv,
1043: msc_demands ass_md,
1044: msc_full_pegging ass_mfp,
1045: msc_full_pegging cmp_mfp,
1046: msc_demands cmp_md,
1043: msc_demands ass_md,
1044: msc_full_pegging ass_mfp,
1045: msc_full_pegging cmp_mfp,
1046: msc_demands cmp_md,
1047: msd_level_values cmp_mlv,
1048: msc_system_items cmp_msi,
1049: msc_plan_organizations cmp_mpo
1050: where ass_mpo.plan_id = p_supply_plan_id
1051: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1101: last_day(mfp1.demand_date) DISABLE_DATE
1102: from
1103: msc_plan_organizations mpo1,
1104: msc_system_items msi,
1105: msd_level_values mlv1,
1106: msc_demands md,
1107: msc_full_pegging mfp1,
1108: msc_full_pegging mfp2,
1109: msc_resource_requirements mrr,
1107: msc_full_pegging mfp1,
1108: msc_full_pegging mfp2,
1109: msc_resource_requirements mrr,
1110: msc_department_resources mdr,
1111: msd_level_values mlv2,
1112: msc_plan_organizations mpo2
1113: where
1114: mpo1.plan_id = p_supply_plan_id
1115: and msi.plan_id = mpo1.plan_id
1114: mpo1.plan_id = p_supply_plan_id
1115: and msi.plan_id = mpo1.plan_id
1116: and msi.organization_id = mpo1.organization_id
1117: and msi.sr_instance_id = mpo1.sr_instance_id
1118: /*msc_system_items and msd_level_values */
1119: and mlv1.instance = msi.sr_instance_id
1120: and mlv1.level_id = 1
1121: and mlv1.sr_level_pk = to_char(msi.sr_inventory_item_id)
1122: /* msc_system_items and msc_demands */
1142: and mrr.resource_id = mdr.resource_id
1143: and mrr.plan_id = mdr.plan_id
1144: and mrr.sr_instance_id = mdr.sr_instance_id
1145: and mrr.organization_id = mdr.organization_id
1146: /* msc_department_resources and msd_level_values */
1147: and mlv2.instance = mdr.sr_instance_id
1148: and mlv2.level_id = 1
1149: and mlv2.sr_level_pk = decode(mdr.resource_id,-1,'L'||'.'||mdr.department_code,'R'||'.'||mdr.resource_code)
1150: /* msc_department_resources and msc_plan_organizations */
1747: cmp_msi.sr_inventory_item_id SR_COMPONENT_PK
1748: from
1749: msc_plan_organizations ass_mpo,
1750: msc_system_items ass_msi,
1751: msd_level_values ass_mlv,
1752: msc_demands ass_md,
1753: msc_full_pegging ass_mfp,
1754: msc_full_pegging cmp_mfp,
1755: msc_demands cmp_md,
1752: msc_demands ass_md,
1753: msc_full_pegging ass_mfp,
1754: msc_full_pegging cmp_mfp,
1755: msc_demands cmp_md,
1756: msd_level_values cmp_mlv,
1757: msc_system_items cmp_msi,
1758: msc_plan_organizations cmp_mpo
1759: where
1760: /* msc_system_items - assembly and msc_plans - assembly */
1761: ass_mpo.plan_id = p_supply_plan_id
1762: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1763: and ass_msi.plan_id = ass_mpo.plan_id
1764: and ass_msi.organization_id = ass_mpo.organization_id
1765: /* msc_system_items - assembly and msd_level_values - assembly */
1766: and ass_mlv.instance = ass_msi.sr_instance_id
1767: and ass_mlv.level_id = 1
1768: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1769: /* msc_system_items - assembly and msc_demands - assembly */
1805: cmp_msi.sr_inventory_item_id SR_COMPONENT_PK
1806: from
1807: msc_plan_organizations ass_mpo,
1808: msc_system_items ass_msi,
1809: msd_level_values ass_mlv,
1810: msc_demands ass_md,
1811: msc_full_pegging ass_mfp,
1812: msc_full_pegging cmp_mfp,
1813: msc_demands cmp_md,
1810: msc_demands ass_md,
1811: msc_full_pegging ass_mfp,
1812: msc_full_pegging cmp_mfp,
1813: msc_demands cmp_md,
1814: msd_level_values cmp_mlv,
1815: msc_system_items cmp_msi,
1816: msc_plan_organizations cmp_mpo
1817: where
1818: /* msc_system_items - assembly and msc_plans - assembly */
1819: ass_mpo.plan_id = p_supply_plan_id
1820: and ass_msi.sr_instance_id = ass_mpo.sr_instance_id
1821: and ass_msi.plan_id = ass_mpo.plan_id
1822: and ass_msi.organization_id = ass_mpo.organization_id
1823: /* msc_system_items - assembly and msd_level_values - assembly */
1824: and ass_mlv.instance = ass_msi.sr_instance_id
1825: and ass_mlv.level_id = 1
1826: and ass_mlv.sr_level_pk = to_char(ass_msi.sr_inventory_item_id)
1827: /* msc_system_items - assembly and msc_demands - assembly */