[Home] [Help]
595: and bic.component_item_id = d1.inventory_item_id
596: and trunc(bic.effectivity_date) <= d1.requirement_date
597: and NVL(bic.disable_date, d1.requirement_date ) + 1 > d1.requirement_date )
598: and ic1.optional = 1 /* optional = yes */
599: and ic1.bom_item_type = 4 /* standard */
600: and d1.config_status = 20
601: and d2.config_status = 20
602: and d1.primary_uom_quantity <> 0
603: and d1.rto_model_source_line = d2.demand_source_line
614:
615:
616: /*
617: ** Second:
618: ** All the standard component items associated
619: ** with the new configuration items will be loaded into the
620: ** BOM_INVENTORY_COMPS_INTERFACE table.
621: */
622:
748: ic1.supply_locator_id
749: from
750: bom_bill_of_mtls_interface b1,
751: mtl_demand d2, /* Model-Parent */
752: mtl_demand d1, /* Standard Mandatory comp */
753: mtl_system_items si1,
754: bom_bill_of_materials b,
755: bom_inventory_components ic1
756: where d1.organization_id = si1.organization_id
777: GREATEST(NVL(d2.estimated_release_date,SYSDATE),SYSDATE)
778: and ic1.implementation_date is not null
779: and NVL(ic1.disable_date,NVL(d2.estimated_release_date,
780: SYSDATE)+1) > NVL(d2.estimated_release_date,SYSDATE)
781: and ic1.bom_item_type = 4; /* standard */
782:
783: /*
784: ** Third:
785: ** All the chosen option classes associated
1271: LAST_UPDATED_BY,
1272: CREATION_DATE,
1273: CREATED_BY,
1274: LAST_UPDATE_LOGIN,
1275: STANDARD_OPERATION_ID,
1276: DEPARTMENT_ID ,
1277: OPERATION_LEAD_TIME_PERCENT,
1278: MINIMUM_TRANSFER_QUANTITY,
1279: COUNT_POINT_TYPE ,
1328: 1, /* last updated by */
1329: SYSDATE, /* creation date */
1330: 1, /* created by */
1331: si1.bom_item_type, /* last update login col stores item type temporarily */
1332: os1.standard_operation_id,
1333: os1.department_id,
1334: os1.operation_lead_time_percent,
1335: os1.minimum_transfer_quantity,
1336: os1.count_point_type,
1426: LAST_UPDATED_BY,
1427: CREATION_DATE,
1428: CREATED_BY,
1429: LAST_UPDATE_LOGIN,
1430: STANDARD_OPERATION_ID,
1431: DEPARTMENT_ID ,
1432: OPERATION_LEAD_TIME_PERCENT,
1433: MINIMUM_TRANSFER_QUANTITY,
1434: COUNT_POINT_TYPE ,
1483: 1, /* last updated by */
1484: SYSDATE, /* creation date */
1485: 1, /* created by */
1486: si1.bom_item_type, /* last update login col stores item type temporarily */
1487: os1.standard_operation_id,
1488: os1.department_id,
1489: os1.operation_lead_time_percent,
1490: os1.minimum_transfer_quantity,
1491: os1.count_point_type,
1582: LAST_UPDATED_BY,
1583: CREATION_DATE,
1584: CREATED_BY,
1585: LAST_UPDATE_LOGIN,
1586: STANDARD_OPERATION_ID,
1587: DEPARTMENT_ID ,
1588: OPERATION_LEAD_TIME_PERCENT,
1589: MINIMUM_TRANSFER_QUANTITY,
1590: COUNT_POINT_TYPE ,
1639: 1, /* last updated by */
1640: SYSDATE, /* creation date */
1641: 1, /* created by */
1642: d2.demand_type, /* Last update login stores demand_type temporarily */
1643: os1.standard_operation_id,
1644: os1.department_id,
1645: os1.operation_lead_time_percent,
1646: os1.minimum_transfer_quantity,
1647: os1.count_point_type,
1747:
1748: /*
1749: ** Third:
1750: ** man: This SQL statement gets all the operations/events that
1751: are option dependent and have a standard mandatory
1752: component at that operation
1753: */
1754: stmt_num := 150;
1755: insert into BOM_OP_SEQUENCES_INTERFACE
1761: LAST_UPDATED_BY,
1762: CREATION_DATE,
1763: CREATED_BY,
1764: LAST_UPDATE_LOGIN,
1765: STANDARD_OPERATION_ID,
1766: DEPARTMENT_ID ,
1767: OPERATION_LEAD_TIME_PERCENT,
1768: MINIMUM_TRANSFER_QUANTITY,
1769: COUNT_POINT_TYPE ,
1819: 1, /* last updated by */
1820: SYSDATE, /* creation date */
1821: 1, /* created by */
1822: si1.bom_item_type, /* last update login col stores item type temporarily */
1823: os1.standard_operation_id,
1824: os1.department_id,
1825: os1.operation_lead_time_percent,
1826: os1.minimum_transfer_quantity,
1827: os1.count_point_type,
1902: and NVL(ic1.disable_date,NVL(d2.estimated_release_date,
1903: SYSDATE)+ 1) > NVL(d2.estimated_release_date,SYSDATE)
1904: and si2.inventory_item_id = ic1.component_item_id
1905: and si2.organization_id = b1.organization_id
1906: and si2.bom_item_type = 4 /* standard */
1907: and or1.assembly_item_id = b1.assembly_item_id
1908: and or1.organization_id = b1.organization_id
1909: and or1.alternate_routing_designator is NULL
1910: and nvl(or1.cfm_routing_flag,2) = nvl(b.cfm_routing_flag,2) /*ensure correct OC rtgs*/
2158: OPERATION_SEQUENCE_ID,
2159: RESOURCE_SEQ_NUM,
2160: RESOURCE_ID ,
2161: ACTIVITY_ID,
2162: STANDARD_RATE_FLAG,
2163: ASSIGNED_UNITS ,
2164: USAGE_RATE_OR_AMOUNT,
2165: USAGE_RATE_OR_AMOUNT_INVERSE,
2166: BASIS_TYPE,
2198: bor.resource_seq_num,
2199: bor.resource_id,
2200: /* resource id */
2201: bor.activity_id,
2202: bor.standard_rate_flag,
2203: bor.assigned_units,
2204: bor.usage_rate_or_amount,
2205: bor.usage_rate_or_amount_inverse,
2206: bor.basis_type,