[Home] [Help]
846:
847: -- cursor component_cursor1 is the cursor that passes down demand
848: -- to the components feeding into a line. Notice that we are driving
849: -- off of bom_operational_routings
850: -- also if supply sub and locator are null in bom_inventory_components
851: -- we get it from wip supply locations from mtl_system_items - this
852: -- is ok for R-11, though we might have an issue here for R12
853:
854: CURSOR component_cursor1 IS
872: mllc.basis_type,
873: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
874: FROM mtl_system_items msi,
875: mrp_low_level_codes mllc,
876: bom_inventory_components bic,
877: bom_bill_of_materials bbom,
878: bom_operational_routings bor,
879: mtl_parameters mp
880: WHERE mp.organization_id = g_kanban_info_rec.organization_id
900: >= g_kanban_info_rec.bom_effectivity
901: AND bic.effectivity_date <= g_kanban_info_rec.bom_effectivity
902: AND NOT EXISTS (
903: SELECT NULL
904: FROM bom_inventory_components bic2
905: WHERE bic2.bill_sequence_id = bic.bill_sequence_id
906: AND bic2.component_item_id = bic.component_item_id
907: AND (decode(bic2.implementation_date, null,
908: bic2.old_component_sequence_id,
1403:
1404: -- cursor component_cursor1 is the cursor that passes down demand
1405: -- to the components feeding into a line. Notice that we are driving
1406: -- off of bom_operational_routings
1407: -- also if supply sub and locator are null in bom_inventory_components
1408: -- we get it from wip supply locations from mtl_system_items - this
1409: -- is ok for R-11, though we might have an issue here for R12
1410:
1411: CURSOR component_cursor1 IS
1429: mllc.basis_type,
1430: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1431: FROM mtl_system_items msi,
1432: mrp_low_level_codes mllc,
1433: bom_inventory_components bic,
1434: bom_bill_of_materials bbom
1435: WHERE
1436: bbom.assembly_item_id = p_assembly_item_id
1437: AND bbom.organization_id = g_kanban_info_rec.organization_id
1453: >= g_kanban_info_rec.bom_effectivity
1454: AND bic.effectivity_date <= g_kanban_info_rec.bom_effectivity
1455: AND NOT EXISTS (
1456: SELECT NULL
1457: FROM bom_inventory_components bic2
1458: WHERE bic2.bill_sequence_id = bic.bill_sequence_id
1459: AND bic2.component_item_id = bic.component_item_id
1460: AND (decode(bic2.implementation_date, null,
1461: bic2.old_component_sequence_id,
1888:
1889: -- cursor component_cursor1 is the cursor that passes down demand
1890: -- to the components feeding into a line. Notice that we are driving
1891: -- off of bom_operational_routings
1892: -- also if supply sub and locator are null in bom_inventory_components
1893: -- we get it from wip supply locations from mtl_system_items - this
1894: -- is ok for R-11, though we might have an issue here for R12
1895:
1896: CURSOR component_cursor1 IS
1914: mllc.basis_type,
1915: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1916: FROM mtl_system_items msi,
1917: mrp_low_level_codes mllc,
1918: bom_inventory_components bic,
1919: bom_bill_of_materials bbom,
1920: bom_operational_routings bor,
1921: mtl_parameters mp
1922: WHERE mp.organization_id = g_kanban_info_rec.organization_id
1942: bic.component_item_id,
1943: mp.organization_id)
1944: AND NOT EXISTS (
1945: SELECT NULL
1946: FROM bom_inventory_components bic2
1947: WHERE bic2.bill_sequence_id = bic.bill_sequence_id
1948: AND bic2.component_item_id = bic.component_item_id
1949: AND (decode(bic2.implementation_date, null,
1950: bic2.old_component_sequence_id,