[Home] [Help]
909:
910: -- cursor component_cursor1 is the cursor that passes down demand
911: -- to the components feeding into a line. Notice that we are driving
912: -- off of bom_operational_routings
913: -- also if supply sub and locator are null in bom_inventory_components
914: -- we get it from wip supply locations from mtl_system_items - this
915: -- is ok for R-11, though we might have an issue here for R12
916:
917: CURSOR component_cursor1 IS
935: mllc.basis_type,
936: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
937: FROM mtl_system_items msi,
938: mrp_low_level_codes mllc,
939: bom_inventory_components bic,
940: bom_bill_of_materials bbom,
941: bom_operational_routings bor,
942: mtl_parameters mp
943: WHERE mp.organization_id = g_kanban_info_rec.organization_id
963: >= g_kanban_info_rec.bom_effectivity
964: AND bic.effectivity_date <= g_kanban_info_rec.bom_effectivity
965: AND NOT EXISTS (
966: SELECT NULL
967: FROM bom_inventory_components bic2
968: WHERE bic2.bill_sequence_id = bic.bill_sequence_id
969: AND bic2.component_item_id = bic.component_item_id
970: AND (decode(bic2.implementation_date, null,
971: bic2.old_component_sequence_id,
1482:
1483: -- cursor component_cursor1 is the cursor that passes down demand
1484: -- to the components feeding into a line. Notice that we are driving
1485: -- off of bom_operational_routings
1486: -- also if supply sub and locator are null in bom_inventory_components
1487: -- we get it from wip supply locations from mtl_system_items - this
1488: -- is ok for R-11, though we might have an issue here for R12
1489:
1490: CURSOR component_cursor1 IS
1508: mllc.basis_type,
1509: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1510: FROM mtl_system_items msi,
1511: mrp_low_level_codes mllc,
1512: bom_inventory_components bic,
1513: bom_bill_of_materials bbom
1514: WHERE
1515: bbom.assembly_item_id = p_assembly_item_id
1516: AND bbom.organization_id = g_kanban_info_rec.organization_id
1532: >= g_kanban_info_rec.bom_effectivity
1533: AND bic.effectivity_date <= g_kanban_info_rec.bom_effectivity
1534: AND NOT EXISTS (
1535: SELECT NULL
1536: FROM bom_inventory_components bic2
1537: WHERE bic2.bill_sequence_id = bic.bill_sequence_id
1538: AND bic2.component_item_id = bic.component_item_id
1539: AND (decode(bic2.implementation_date, null,
1540: bic2.old_component_sequence_id,
1983:
1984: -- cursor component_cursor1 is the cursor that passes down demand
1985: -- to the components feeding into a line. Notice that we are driving
1986: -- off of bom_operational_routings
1987: -- also if supply sub and locator are null in bom_inventory_components
1988: -- we get it from wip supply locations from mtl_system_items - this
1989: -- is ok for R-11, though we might have an issue here for R12
1990:
1991: CURSOR component_cursor1 IS
2009: mllc.basis_type,
2010: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
2011: FROM mtl_system_items msi,
2012: mrp_low_level_codes mllc,
2013: bom_inventory_components bic,
2014: bom_bill_of_materials bbom,
2015: bom_operational_routings bor,
2016: mtl_parameters mp
2017: WHERE mp.organization_id = g_kanban_info_rec.organization_id
2037: bic.component_item_id,
2038: mp.organization_id)
2039: AND NOT EXISTS (
2040: SELECT NULL
2041: FROM bom_inventory_components bic2
2042: WHERE bic2.bill_sequence_id = bic.bill_sequence_id
2043: AND bic2.component_item_id = bic.component_item_id
2044: AND (decode(bic2.implementation_date, null,
2045: bic2.old_component_sequence_id,