[Home] [Help]
864: wdd.delivery_detail_id,
865: wdd.requested_quantity,
866: mtl.serial_number_control_code
867: FROM csd_repairs cr,
868: mtl_system_items_b mtl,
869: cs_estimate_details ced,
870: wsh_delivery_details wdd,
871: --Changed to view from table, bug: 4341784
872: wsh_delivery_assignments_v wda
1333: p.organization_code
1334: FROM wsh_delivery_details a,
1335: --Changed to view from table, bug: 4341784
1336: wsh_delivery_assignments_v b,
1337: mtl_system_items c,
1338: mtl_parameters p
1339: WHERE a.delivery_detail_id = b.delivery_detail_id
1340: AND a.inventory_item_id = c.inventory_item_id
1341: AND a.organization_id = c.organization_id
2291: l_orig_src_reference VARCHAR2(30);
2292: l_orig_src_header_id NUMBER;
2293: l_orig_src_line_id NUMBER;
2294: l_orig_po_num VARCHAR2(50);
2295: l_rev_ctl_code mtl_system_items.revision_qty_control_code%TYPE;
2296: l_booked_flag oe_order_headers_all.booked_flag%TYPE;
2297:
2298: --taklam
2299: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3048:
3049: BEGIN
3050: SELECT revision_qty_control_code
3051: INTO l_rev_ctl_code
3052: FROM mtl_system_items
3053: WHERE organization_id =
3054: Cs_Std.get_item_valdn_orgzn_id
3055: AND inventory_item_id =
3056: x_product_txn_rec.inventory_item_id;
9099: THEN
9100: BEGIN
9101: SELECT Serial_Number_Control_COde
9102: INTO l_Serial_num_COntrol_Code
9103: FROM Mtl_System_Items_B
9104: WHERE Inventory_Item_Id = l_Inventory_Item_Id
9105: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;
9106: -- If item is serial controlled then raise error
9107: IF l_Serial_num_COntrol_Code > 1
9118: WHEN NO_DATA_FOUND THEN
9119: -- Get Item Name
9120: SELECT items.concatenated_segments
9121: INTO l_Item_Name
9122: FROM mtl_system_items_vl items, csd_repairs dra
9123: WHERE dra.repair_line_id = p_Repair_Line_Id
9124: and dra.inventory_item_id = items.inventory_item_id
9125: and items.organization_id = cs_std.get_item_valdn_orgzn_id;
9126: