[Home] [Help]
29: x_return_status OUT NOCOPY varchar2)
30: IS
31: CURSOR ato_option_cur(p_ato_line_id in number) IS
32: SELECT oel.line_id
33: FROM mtl_system_items msi,
34: oe_order_lines_all oel
35: WHERE oel.ato_line_id = p_ato_line_id
36: AND oel.item_type_code = 'OPTION'
37: AND nvl(oel.cancelled_flag,'N') <> 'Y'
1721: to_number(null) ib_current_loc_id,
1722: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1723: FROM oe_order_headers_all ooh,
1724: oe_order_lines_all ool,
1725: mtl_system_items msi,
1726: mtl_unit_transactions mut,
1727: mtl_material_transactions mmt,
1728: mtl_secondary_inventories msei,
1729: hr_all_organization_units haou
1780: to_number(null) ib_current_loc_id,
1781: ooh.order_source_id order_source_id -- Added for Siebel Genesis Project
1782: FROM oe_order_headers_all ooh,
1783: oe_order_lines_all ool,
1784: mtl_system_items msi,
1785: mtl_unit_transactions mut,
1786: mtl_transaction_lot_numbers mtln,
1787: mtl_material_transactions mmt,
1788: mtl_secondary_inventories msei,
4358: sum(required_quantity) qty_required,
4359: sum(quantity_issued) qty_issued,
4360: sum(quantity_per_assembly) qty_per_assy
4361: FROM wip_requirement_operations wip,
4362: mtl_system_items msi
4363: WHERE wip_entity_id = p_wip_entity_id
4364: AND wip.organization_id = p_organization_id
4365: AND wip.inventory_item_id = msi.inventory_item_id
4366: AND wip.organization_id = msi.organization_id
4419: IF req_rec.qty_per_assy > 0 THEN
4420:
4421: SELECT serial_number_control_code
4422: INTO l_serial_code
4423: FROM mtl_system_items
4424: WHERE inventory_item_id = req_rec.inventory_item_id
4425: AND organization_id = p_organization_id;
4426:
4427: IF l_serial_code in (2, 5) THEN