[Home] [Help]
835: FND_MESSAGE.Set_Name ('ONT','ONT_SMC_PICK_RELEASED');
836: BEGIN
837: SELECT ORDERED_ITEM,inventory_item_id
838: INTO l_model_name,l_model_item_id
839: FROM OE_ORDER_LINES
840: WHERE line_id = p_line_rec.top_model_line_id;
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: l_model_name := null;
1055: END IF;
1056:
1057: SELECT ordered_item, item_type_code,inventory_item_id,ordered_quantity
1058: INTO l_ordered_item, l_item_type_code,l_inv_item_id,l_ordered_quantity
1059: FROM oe_order_lines
1060: WHERE line_id = p_line_rec.top_model_line_id;
1061:
1062: IF MOD(p_line_rec.ordered_quantity,l_ordered_quantity) <> 0 THEN
1063:
1921: ELSE
1922:
1923: SELECT inventory_item_id
1924: INTO l_ref_inventory_item_id
1925: FROM oe_order_lines
1926: WHERE line_id = p_reference_line_id;
1927:
1928: IF (l_ref_inventory_item_id = p_inventory_item_id) THEN
1929: RETURN TRUE;
1993: INTO l_ref_fulfilled_quantity
1994: , l_ref_shippable_flag
1995: , l_ref_inv_iface_status
1996: , l_ref_shipped_quantity
1997: FROM oe_order_lines
1998: WHERE line_id = p_reference_line_id;
1999:
2000: IF (l_ref_shippable_flag = 'N' AND l_ref_inv_iface_status = 'NOT_ELIGIBLE') THEN
2001: RETURN TRUE;
2103: end if;
2104:
2105: SELECT tax_code
2106: INTO l_tax_code
2107: FROM oe_order_lines
2108: WHERE line_id = p_reference_line_id
2109: and line_category_code = 'ORDER';
2110:
2111: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN
2157: source_document_type_id
2158: INTO l_booked_flag,
2159: l_uom_code,
2160: l_source_document_type_id
2161: FROM oe_order_lines
2162: WHERE line_id = p_reference_line_id
2163: and line_category_code = 'ORDER';
2164:
2165: IF l_source_document_type_id = 10 THEN
2223: END IF;
2224:
2225: SELECT NVL(SUM(ordered_quantity),0)
2226: INTO l_ord_qty
2227: FROM oe_order_lines
2228: WHERE line_category_code= 'RETURN'
2229: and reference_line_id = p_line_id;
2230:
2231: IF l_debug_level > 0 THEN
2833: Select arrival_set_id,
2834: ship_set_id
2835: Into l_arrival_set_id,
2836: l_ship_set_id
2837: FROM OE_ORDER_LINES_ALL
2838: Where line_id = p_line_rec.top_model_line_id;
2839:
2840: EXCEPTION
2841: WHEN OTHERS THEN
3609: THEN
3610:
3611: SELECT item_type_code, ato_line_id
3612: INTO x_item_type_code, x_ato_line_id
3613: FROM oe_order_lines
3614: WHERE line_id = p_line_rec.reference_line_id;
3615:
3616: x_line_id := p_line_rec.reference_line_id;
3617: END IF;
3749: CURSOR c_transaction_quantity IS
3750: SELECT ABS(mmt.transaction_quantity) transaction_quantity,
3751: mmt.transaction_uom,
3752: mmt.revision
3753: FROM oe_order_lines_all ool, mtl_material_transactions mmt
3754: WHERE ool.line_id = p_line_rec.reference_line_id
3755: AND mmt.transaction_source_type_id = 2
3756: AND mmt.transaction_type_id = 33
3757: AND mmt.trx_source_line_id = ool.line_id
4256: BEGIN
4257:
4258: select sum(ordered_quantity)
4259: into l_quantity_entered
4260: from oe_order_lines
4261: where reference_line_id = p_line_rec.reference_line_id
4262: and line_category_code = 'RETURN'
4263: and item_revision = p_line_rec.item_revision
4264: and sold_to_org_id = p_line_rec.sold_to_org_id
4506:
4507: BEGIN
4508: SELECT 'N'
4509: INTO l_valid_line_number
4510: FROM oe_order_lines L
4511: WHERE L.line_number = p_line_rec.line_number
4512: AND L.header_id = p_line_rec.header_id
4513: AND L.line_id <> p_line_rec.line_id
4514: AND ( L.item_type_code = 'STANDARD'
4575: IF l_debug_level > 0 THEN
4576: oe_debug_pub.add('ROLLBACK THE CHANGES ' ,2);
4577: END IF;
4578:
4579: UPDATE OE_ORDER_LINES_ALL
4580: SET SCHEDULE_SHIP_DATE = p_old_line_rec.schedule_ship_date,
4581: SCHEDULE_ARRIVAL_DATE = p_old_line_rec.schedule_arrival_date,
4582: SHIP_FROM_ORG_ID = p_old_line_rec.ship_from_org_id
4583: WHERE top_model_line_id = p_line_rec.top_model_line_id;
6410: -- this is a decrement and not a cancellation.
6411:
6412: SELECT count(*)
6413: INTO l_option_count
6414: FROM oe_order_lines
6415: WHERE top_model_line_id = p_line_rec.line_id
6416: AND line_id <> p_line_rec.line_id;
6417:
6418: IF l_option_count > 0 THEN